counting

[faye]

in a report how can one count only the number of
checkboxes that are checked?? i have been able to set
column totals for number of cases, and other columns, both
in sections of the report and for an overall total. i can
get a total for the number of boxes but i need to be able
to count only those that are checked.. any hints?
thanks in advance

 

[Fredg]

Add them up.
A Yes/No field can only have a value of -1 or 0.

To count Yes's:
To count Yes (-1) values, add them up.
The ABS() function then returns a positive value.
i.e. If there are 8 Yes values the sum -8 becomes 8.

=ABS(Sum([CheckBoxfield]))


To count No's:
Again, add them up.

A No value (0) has 1 added to it.
It's value is now 1.
A Yes value (-1) has 1 added to it.
It's value now is 0.

=Sum([CheckBoxField]+1)

Hope this is clear.