This is my original equation: =([Total Maintain Exercise]/[Total

Completing 1 mo Follow-up])*100

When the denomimator is zero I am unable to calculate the percentage.

I tried changing my equation to this format:

=IIf([denominator_field] = 0, 0, [numerator_field]/

[denominator_field])

I also tried:

IF(B=0,0,A/B) will give you an answer of 0 if the

denominator is zero or IF(B=0,"",A/B) will give you a blank in the

same

situation.

Any suggestions...I am desperate as I was hoping this would be an EASY

fix!

Thanks!,

John