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