Error from division by 0

R

Ray

I have a report that shows paid and unpaud memberships and has a calculated
control to show the percentage. However it returns #error if the numbers are
0. (naturally) How can I overcome this in the report and have it just put a
0% instead of #error

Thanks
 
D

Damian S

Hi Ray,

use this:

=iif (isnull(DIVIDING_FIELD), 0, TOTAL_FIELD/DIVIDING_FIELD)

Hope this helps.

Damian.
 
Top