Dividing totals created by check boxes

[Ron A.]

--I need to divide the total number of fail by the total number of
inspection to get a fail percentage in a report. The expression I used to get
total inspections is:

=Sum( Abs( [Pass]+[Fail] ) )

The Pass and Fail data are check boxes and I want to put these totals in a
report header.

Aloha,
Ron A.

 

[Rick Brandt]

--I need to divide the total number of fail by the total number of
inspection to get a fail percentage in a report. The expression I
used to get total inspections is:

=Sum( Abs( [Pass]+[Fail] ) )

The Pass and Fail data are check boxes and I want to put these totals
in a report header.

Aloha,
Ron A.

Since a false CheckBox = 0 then no matter how many fails you have they will
never affect the result of the expression you have there. All you are doing is
adding the passes.

Do a Count instead of a Sum.