Count instances of specific values in a field

[Benj]

Is there anyway I can get FM to return in (a) summary field(s) the number of instances of several specific values from a single field? e.g. How many times "10" appears, and how many times "20" appears, and how many times "30" appears etc.

Thanks, Ben

[CobaltSky]

One way is to set up a Summary field and a layout which provides sub-summaries when sorted by the value in question. Then perform a find to locate the values you want to check on, switch to your sub summary and sort and you will get the breakdown.

Another way is to set up a script which does a find for each of the values in turn and writes the number of records found to a global field.

A third way, which has the advantage of dynamically updating its display as anything in the database changes, could be achieved by:

1. Creating a global number field to hold each value you want to count,

2. Create a self-join relationship which links each of the global fields to the value field you are targetting (ie one relationship for each value you are counting)

3. Create a separate unstored calculation field for each relationship, with a formula along the lines of: Count(ValueCountOne::YourValueField)

These calculating fields will provide a dynamically updating 'read-out' of the number of each value in the database.

There are other methods and also numerous variations on each, but the above suggestions should give you some ideas to work with...