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 -> ORA-01476 divisor is equal to zero error

ORA-01476 divisor is equal to zero error

From: Darren <darren.marley_at_cw.com>
Date: 21 May 2004 08:14:41 -0700
Message-ID: <648d6ffd.0405210714.ff107f@posting.google.com> 





Can anyone help,


 I'm trying to create a simple condition where Revenue / Total_duration = PPM.
 but keep coming across the same issue .



This is the part of the code I'm having problems with.



 SUM(DECODE(PERIOD_YR_MTH,'200404',REVENUE/TOTAL_DURATION,0)) AS PPM


Does anyone have a solution?
Received on Fri May 21 2004 - 10:14:41 CDT












Original text of this message













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