Counting Checkboxes

  • Thread starter Thread starter quixote
  • Start date Start date
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
 
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).
 
Back
Top