Report error

[Phil]

When I run my query I get the following:
truck_nm SumOfivh_net_amt Margin Profit
#207 FLAT BOOM $0.00 #Error $0.00
#625 FLAT BOOM $11,217.48 28.04% $3,145.05

I understand this is because of dividing 0 by 0 and trying
to output a percentage...but my report gives me an error
and will not even output the #Error on it...how can I fix
this?

 

[Wayne Morgan]

Change the equation to

IIf(denominator = 0, 0, numerator/denominator)