counting

[g4macuser]

how do i go about creating a new field (FieldB) to count the number of times FieldA contains the number 5 over a sorted set of 20 of 60 records.

basically i am not sure of the field type and the formula/funtions to use.

i am sure this can be done, it seems so simple to do in theory but who knows. thanks.

[QuinTech]

Hi, g4, and welcome to FM Forums! Unless the number 5 has a special significance, you're best off using subsummaries. That is, if you'll also want to know the number of occurrences of the number 6, and 7, and 8... use subsummaries.

If 5 is not just an exemplar, but is really significant, create a calc number field called Always5 that is always equal to 5. Make a relationship from Always5 to FieldA and call it FindTheFives. Now the calc you want for FieldB is

Count ( FindTheFives::FieldA )

This will display the number you are looking for, irregardless of the current found set or any sorting.

HTH.

Jerry