Return to FileMaker.com
sum or count calculation with filter?
I have 600 records and I want to count how many different names I have in a field.
So if the name bob was used 300 times it would only count it once. I want to place this in the footer of my layout.
Here's one way to do this.
Set up a value list that refers to this field. In the value list, "bob" will only appear once.
Then this calculation will count the number of different values in your value list--which will be the number of unique values in your field:
ValueCount ( ValueListItems ( Get ( FileName ) ; "valueListNameInQuotes" ) )
Retrieving data ...