Re: Divide by zero
From: Harlan Messinger <zzzhmessinger_at_erols.com>
Date: Thu, 29 Mar 2001 15:38:19 -0500
Message-ID: <9a06bv$174$1_at_bob.news.rcn.net>
Date: Thu, 29 Mar 2001 15:38:19 -0500
Message-ID: <9a06bv$174$1_at_bob.news.rcn.net>
Check your parentheses. You have
DECODE( ((COST,0,NULL - BASE_SALE_UNIT_PRICE)) /COST )*100
You can't divide ((COST,0,NULL - BASE_SALE_UNIT_BRACE)) by COST.
"Andy" <konopam_at_yahoo.com> wrote in message
news: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:
> 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'
> Or LINE_STATE='Delivered'
>
>
Received on Thu Mar 29 2001 - 22:38:19 CEST