### Title

Report, counting the number of unique values in a field

### Post

I need to generate a report (using Filemaker Pro 11) where the number of unique values of a particular field are counted. (Specifics: Multiple schools participating in multiple events; I need a count of the number of schools participating. If a school participates in multiple events, it is just counted once.)

I'd appreciate any help in how to do this. The "!" to find duplicates isn't much help. I tried "omitting" "!", but that doesn't help either.

Thanks for any ideas.

Joel Goodman

There's a rather funky trick called 'sum the reciprocal' you can use: A new way to count unique values in FileMaker 12

In some other situations, you can define a conditional value list (which automatically excludes duplicates) and a count of the values in this value list will produce the same results.

Note to FMP 12 users:

Youhave the option to use the Execute SQL function to get this same unique count and it's a much simpler way to go.