AnsweredAssumed Answered

Counting Counties

Question asked by mcoslo on Dec 15, 2017
Latest reply on Dec 15, 2017 by philmodjunk

I have  text files  that are imported into Excel, then Filemaker. I need to serach the contents of one of the fields, named "TheirCounty", then assign a value of 1 into another field. Then repeat until all the counties there are found Then the fields that had the 1 inserted into them are summed up with a total number of  different counties that were contacted. 1 point per county, with only only no matter how many separate instances of the county showing up in the "TheirCounty" field.

 

The summing works okay, but I'm having a tough time performing what should be pretty simple. I've attached the work in progress.

Attachments

Outcomes