Divide by zero
From: Andy <konopam_at_yahoo.com>
Date: Thu, 22 Mar 2001 16:44:13 -0600
Message-ID: <ffvu6.5418$7e6.1969932_at_homer.alpha.net>
Date: Thu, 22 Mar 2001 16:44:13 -0600
Message-ID: <ffvu6.5418$7e6.1969932_at_homer.alpha.net>
I would like to know why I cannot use a decode here to avoid a possible
divide by zero in this sql statement:
Or LINE_STATE='Delivered'
Received on Thu Mar 22 2001 - 23:44:13 CET
SELECT CATALOG_NO, CATALOG_DESC, QTY_SHIPPED, LINE_STATE,
catalog_no,BASE_SALE_UNIT_PRICE,
COST, REAL_SHIP_DATE,
DECODE(((COST,0,NULL - BASE_SALE_UNIT_PRICE))/COST)*100
AS GrossMargin
FROM CUSTOMER_ORDER_JOIN
WHERE LINE_STATE='Invoiced/Closed'