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 IamaSherpa 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
Mar 11, 2002
2
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