Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to eliminate divide by zero error

How to eliminate divide by zero error

From: D <email0203_at_comcast.net>
Date: 8 Mar 2007 13:26:06 -0800
Message-ID: <1173389166.836564.101920@s48g2000cws.googlegroups.com>


Hello - I'm looking to eliminate the divide by zero error using coalesce on the following code. Not sure how to incorporate on another
function. Please help!!

(round((case when(d.NUM_INC)=0 then 0 else (d.DUR_INCd. IN_WRAPUP_TIMEd.
DUR_HOLD)/d.NUM_INC end),0)/round(((case when(d.NUM_INC)=0 then 0 else (d.DUR_INC-d.IN_WRAPUP_TIME-d.DUR_HOLD)/d.NUM_INC end + case

when(d.NUM_INC)=0 then 0 else d.DUR_HOLD/d.NUM_INC end + case
when(d.NUM_INC)=0 then 0 else (d.OUT_WRAPUP_TIME+d.IN_WRAPUP_TIME)/
d.NUM_INC end)),0))
Received on Thu Mar 08 2007 - 15:26:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US