work around #Num! Error when dividing by 0?

[JCross]

I have a calculation on my report that sometimes ends up dividing by 0 - and when it does, it comes up with a #Num! error. I tried to Nz it, but it didn't work, any suggestions?

=([ExtensionA]+[CostB]+[CostC]-[ExtensionE])/[SumCount]

is my control source.

Thank you!

Jennifer

 

[pcs]

not sure if my parens are correct, but try something like:

=IIF([SumCount]>0,([ExtensionA]+[CostB]+[CostC]-[ExtensionE])/[SumCount]),0)


hth,
al

 

[JCross]

YAY! The parens wound up like this

=IIF([SumCount]>0,(([ExtensionA]+[CostB]+[CostC]-[ExtensionE])/[SumCount]),0)

and then it worked perfectly.

Thank you!

Jennifer