7 Replies Latest reply on Nov 13, 2014 9:11 AM by philmodjunk

    Counting values in a list?

    TMEG

      Title

      Counting values in a list?

      Post

      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.