Counting Various Fields

[Jason Rogers]

I know how to use count so that I count all the records in my report, but is
it possible to count records meeting certain conditions? In other words, I
have a report that has a Yes/No field on it, and I'd like to be able to
count all the records that have Yes in them and display the total. Same
thing with a check box I have, I'd like to count all the records where the
box is checked. Any help is greatly appreciated. Thank you.

 

[Duane Hookom]

A yes/no field stores either 0 or -1. To count the yes values, use:
=Abs( Sum([YourField]) )