Skip to Content
0
Former Member
Feb 28, 2008 at 10:55 PM

zero divide error in my query

11 Views

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