How to exclude certain records from an average
I'm a Filemaker Pro 8 - MAC user.
For one of my reports, I use three fields. Time A, Time B, and Time C
for some records -any given one of these fields can be left blank.
I want to create an average field in a summary (i.e., Average Time A, Average Time B, and Average Time C).
However, I want the average to show in my leading summary, and only be based on fields that contain data. I do not want empty fields to be included in the average, for obvious reasons (it distorts the data).
Thanks so much.