Getting a total of a certain value in a field in same table?

[Chrism]

Hi,

Table has field called Field1, I would like summary total of the current found set to say how many time 'Apple' is in the Field1

Is this possible?

[comment]

It is possible, but it will require two fields: a summary field defined as List of Field1 and a calculation field (result is Number) =

ValueCount ( FilterValues ( sList ; "Apple" ) )

where sList is our summary field.

The reason why this is not simple is that no single value in Field1 is supposed to be special. Filemaker provides a simple way to produce a separate count for each and every value: sort the found set by Field1 and place a summary field counting the records in a sub-summary by Field1 part.

 

[Chrism]

Great thank you!