Counting Checkboxes

Q

quixote

How can I count the number of checked checkboxes on a
report? I want to get a percentage, so I need:
(Number of Checked Checkboxes/Total Number of Checkboxes)*
100.

Thanks you
 
F

fredg

How can I count the number of checked checkboxes on a
report? I want to get a percentage, so I need:
(Number of Checked Checkboxes/Total Number of Checkboxes)*
100.

Thanks you
Click to expand...

In the Report Footer:
=ABS(SUM([CheckBoxField]))/COUNT([CheckBoxField])*100

The Sum function of Check boxes will return the number of checked
boxes.
The ABS() function will make the result a positive value.
The Count() function will get the total number in the report (checked
and unchecked).
 
Top