Can a surpress the Div/0 error on a report calculation?
R Rick B Jan 24, 2005 #2 Just put the calculation in an IF statement and if the denominator is zero, then display "n/a" or nothing. Rick B
Just put the calculation in an IF statement and if the denominator is zero, then display "n/a" or nothing. Rick B
D Dirk_Bob Jan 24, 2005 #3 Rick B, Thanks, how would I format that. Right now my equation is margin/invoiced amount
R Rick B Jan 24, 2005 #4 Untested, but I think it would be something like... If (Not(Invoiced amount =0), margin/invoiced amount, "") or If (Invoiced amount <>0, margin/invoiced amount, "") Rick B
Untested, but I think it would be something like... If (Not(Invoiced amount =0), margin/invoiced amount, "") or If (Invoiced amount <>0, margin/invoiced amount, "") Rick B
