AnsweredAssumed Answered

Count unique values in records after Perform Find

Question asked by cnschulz on Jan 30, 2017
Latest reply on Feb 1, 2017 by philmodjunk

Hi,

 

I have found this article : Counting the number of unique values in a field | FileMaker that allows me to count the unique number of clients we have in our job database. This database contains many jobs for each client. We have tried option 2 and 3 in the link above and both are successful at showing the distinct number of clients for *all* records in the database. We then do a search for another attribute to limit the result set (eg: by year) and then the resultant count just shows a "?".

 

Can anyone offer a suggestion on how to show a summary field that counts the number of distinct clients in a job database and is then filterable by other parameters contained in each record?

 

Many thanks.

Outcomes