AnsweredAssumed Answered

Averaging with empty fields, revisited

Question asked by EvanKline on Jul 17, 2014
Latest reply on Jul 18, 2014 by philmodjunk


Averaging with empty fields, revisited


     I found this post as I try to understand why an empty field is still being included in a calculation that uses an average:

     Either I'm not understanding things properly (most likely), or FileMaker has changed in the past few years and that info is no longer correct.


     I'm using this calculation to take the average of a column of averages in a portal (yes, an average of averages, of sorts):

     Sum(Cases::PercentIncreaseOverDDO)/Count ( Cases::__fkAdjusterID )

     However, that is figuring in any empty values (values with a "?" as the value). In the image below, the last column is coming up as 8.42%, when I'd like it to be 12.63% 


     Is there something that I'm doing wrong? Is there a way to get it to ignore fields that are empty?