Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to eliminate divide by zero error
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
![]() |
![]() |