Counting true checkboxes

[Ken]

I have a report that currently displays 50 records. Each record includes a
checkbox and 20 of them are currently "true". In my Report Footer, I'd like
to display a tally of the "true" checkboxes. However, if I do a
"=Count([Checkbox])", my result = 50. What do I need to do to tally only the
"true" checkboxes? Thanks.

 

[John Spencer]

Count counts any Checkbox that has a value and all checkboxes have a value
of True(-1) or False(0). The only thing count does not count is null
values.

You can get the results you want using

=Abs(Sum([CheckBox]))

or

= Count(IIF([CheckBox] = True,1,Null))