AnsweredAssumed Answered

How to exclude certain records from an average

Question asked by imgaryshap on Nov 15, 2009
Latest reply on Nov 16, 2009 by imgaryshap

Title

How to exclude certain records from an average

Post

Hello,


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).

 

any suggestions?

 

Thanks so much.

 

-Gary 

Outcomes