Count Number of Yes's in a Yes/No field

S

Suliman

I have two Yes/No fields, one for Contract Awarded and one for Contract Lost.
When I run a report I would like a count of each field. That way I know how
many proposals are still outstanding (based on how many have been sent) and
can use that info to calculate award percentages and outstanding percentages,
etc. Thanks for your help in advance.
 
R

Rick Brandt

Suliman said:
I have two Yes/No fields, one for Contract Awarded and one for Contract Lost.
When I run a report I would like a count of each field. That way I know how
many proposals are still outstanding (based on how many have been sent) and
can use that info to calculate award percentages and outstanding percentages,
etc. Thanks for your help in advance.
Click to expand...

Since "Yes" values are stored as negative one you can simply sum those fields
and then get the absolute value.

=Abs(Sum([Contract Awarded])
 
Top