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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Group Footer DLookUp 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Dividing by Zero in Access Reports 9
Cross Tab Report Vs Dynamic coulmns 0
Hiding a #Num! occurrence in a report output 4
Creating a Chart on form from selected data in query. 0
Division by Zero Error 1
Expressions in Sub headers 1

Top