Dividing totals created by check boxes

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

Guest

--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.
 
Ron said:
--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.
Click to expand...

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.
 
Back
Top