Error from division by 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Ray,

use this:

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

Hope this helps.

Damian.
 
Back
Top