topic Re: zero divide error in my query in Application Development and Automation Discussions

zero divide error in my query

Former Member — Thu, 28 Feb 2008 22:55:24 GMT

Hi Gurus

I keep getting a 0 divide error in my query, I think it's because some of the invoices have updated for 0.00 dollars, then we've fixed them and released them to accounting but you know these crap structures, they retain each document history, so have kept the 0.00 values.

THis is my calculation, can you see anything obviously wrong with it puleeeese.

CONT_MARG / (MAT_PRC-FRGT_PROV+ DISC_SURC+FREIGHT ) *100

thank u in advanced

Piroz

Re: zero divide error in my query

Former Member — Thu, 28 Feb 2008 22:59:03 GMT

if not MAT_PRC-FRGT_PROV < 0 and

not DISC_SURC-FREIGHT < 0.

formula...

endif.

Re: zero divide error in my query

Former Member — Thu, 28 Feb 2008 22:59:34 GMT

Hi,

Maybe one of them has value -1 oter 1 and than you get 0. Just debug it. Or log the cases when this expression below is equal to 0.

MAT_PRC-FRGT_PROV+ DISC_SURC+FREIGHT

/wg

Re: zero divide error in my query

Former Member — Fri, 29 Feb 2008 00:33:43 GMT

Hi,

I would suggest to calculate the denominator first.

A = (MAT_PRC-FRGT_PROV+ DISC_SURC+FREIGHT ) * 100

If A > 0 then perform the other calculation of dividing the value by A.

This should solve problem.

Regards,

Shahu