Jump to content

"Count if" in a filed


This topic is 2638 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I've done a lot of searching on this and can't find a solution. All I need to do is count how many records in one field has the word "clacorp.org" and also the word "sadccf.org". The field only has two allowable entries, which are: "clacorp.org" and "sadccf.org". I would like to get a count of the "clacorp.org" entry and put the number count in one field and get the count of "sadccf.org" and put the number in another field. 

I tried: ValueCount( FilterValues( List( domain_name); "sadccf.org")) and other caulations but can not get the numbers I need. 

I am only using one table. I need to know how many clacorp.org emails and how many sadccf.org emails. Seems simple but I am stumped.  

Edited by Grady Tracy
Link to comment
Share on other sites

two new calc fields: 

isClacorp = PatternCount ( domain_name ; "clacorp.org" )   

isSadccf  = PatternCount ( domain_name ; "sadccf.org" )

two summary fields:

isClacorpCount = Sum ( isClacorp)

isSadccf = Sum ( isSadccf )

  • Like 1
Link to comment
Share on other sites

  • Newbies

Thank you so much for your help. The solution you gave worked great. I tried the "patterncount" but I did not do the summary field. I went to bed last night when this problem running through my head. I had a hard time sleeping last night, so I was happy to see the response when I woke up this morning. Thank you so much for your help!

Edited by Grady Tracy
Link to comment
Share on other sites

actually I think I was also over tired when I posted -

the latter two fields would be a Summary field using the Total of the corresponding fields. however that only evaluates correctly to the found set of records as a summary operate on the found set.

 

Link to comment
Share on other sites

This topic is 2638 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.