Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Count

Status
Not open for further replies.

nickholt22

Technical User
Joined
Mar 11, 2002
Messages
2
Location
GB
I am trying to perform a count on a field which contains a boolean value and I just wish to count the ones which are "True".
there is a Count formula which is set up:
Count(Fld, CondFld, Cond) but i dont know what to put in the CondFld bit.
Any ideas?
 
I created a formula that assigned all true values = 1:

if field = true then
1

then I summed that formula field, which gave me a count of all the true values.

Hope this helps!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top