Help Report Calculation

[mtriolo]

I am having a problem in getting the correct formula to calculate the number of reinspections in a report. What I need is to calculate the number of reinspections in two separate fields. This report is tied to a query that has Date of Reinspection, Reinspections(number of reinspections), Office, Claim handlers first name, claim handlers last name, and % Difference. The date of reinspection has criteria Between[Enter Beginning Date]AND[Enter Ending Date].

In the report I have added one unbound field with =Count([Reinspections]) which works perfectly.

I added a second unbound field with =IIf([%Difference]=0,Count([Reinspections]),"0") this calculation gives me the same count as the above. What I am looking to do is count the number of reinspections where the %Difference = 0% and if there are no 0% reinspection then I need the field to reflect 0.

Any suggestions?

Thanks Mike

 

[mtriolo]

The formula worked - thank you. I am trying to learn what expression is best used in a particular calculation.

I do have one additional error - I have set up a total field in the report footer and I would like to sum up the numbers in that column but I am getting a negative number(-91) when it should be 91.

Any suggestions. I used the formula =Sum([%Difference]=0).

 

[Rich]

Abs(Sum( etc.........

 

[mtriolo]

Thanks for the help - The report works.

 

[rhett7660]

Rich,,,,

Thank you very much fo rthe Abs(Sum. Worked like a charm.