You have two options for computing an average drawn from a group of records.
- Use an "average of" summary field. If you perform a find to exclude records you don't want (such as puppys) you can place this field in a grand summary, header or footer layout part to see the average for all the records in your found set. You can also place this field in a sub Summary part and get the average for a sub group of the total set of groups.
- Use the Average function. This is an aggregate function and if you set up a table with a relationship that matches only to the group of records you want to average, Average ( relatedtable::measurementfield ) will compute the average. You could thus set up a table with one record for each group that you want an average of with fields that select a specific group of dogs and can then get averages for each.
To count how many "EX" ratings, use a calcualtion like this: (CoatQuality = "EX") + (Conformation = "EX") + .....
CoatQuality = "EX" returns 1 if this is true and 0 if it is not so adding these expressions together will count the number of fields that were rated "EX".
Note: Given the number of such ratings, it might simplify your system to put each rating in a related table instead of using so many dedicated fields. Your table might be structured like this:
ExFlag : Rating = "EX"
Then Sum ( RatingsTable::ExFlag ) would count the number of EX ratings a dog would receive.
Thanks so much for the help - I knew I was missing something basic! I did end up doing some of it by hand, took less time than setting up tables / fields for a one time project. But it got done.