Calculations in a report that have a zero 1

[oliver10]

I have created a report for our radiology department which requires the repeated exams to be divided by the exposures.

ie: =sum([repeats])/([exposures]) but if there is a zero in both columns that are divided - how can I make it return a zero instead of giving a #Num! appearing on the report. The format is in the percent catagory with 2 place decimal.

Thanks, Oliver

 

[tlbroadbent]

=sum(iif [exposures]=0, 0, ([repeats])/([exposures])) Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.