AnsweredAssumed Answered

Counting values in a list?

Question asked by TMEG on Nov 10, 2014
Latest reply on Nov 13, 2014 by philmodjunk


Counting values in a list?


FMP 10.0v3

I've created a layout containing a list of found zip codes. But that list displays each zip code every time it occurs in the found set. What I need is for each zip code to appear only once and to display in an adjacent field the number of times that zip code occurs in the found set.  Like this:

Zip           # of occurrences
91301                23
91305                16
91309                12

Is there a way to do this?

I've tried creating a Unique Count Summary field but that only displays the number of zip codes which are unique in the found set.

Thanks for any clues.