2 Replies Latest reply on Jul 18, 2014 6:13 AM by philmodjunk

    Averaging with empty fields, revisited

    EvanKline

      Title

      Averaging with empty fields, revisited

      Post

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

      http://forums.filemaker.com/posts/b66c925cff?commentId=29160#29160

           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?