3 Replies Latest reply on Jan 17, 2014 6:55 AM by Joshua Milligan

    Want to exclude a specific value from being included in an Average - AVG()

    Rich Wask


      I am creating an average (AVG) including each row of data for a specific data field (i.e. AVG([datafield] ).  this is working.

      When data for "datafield" cannot be found by the app., "999" is populated in the "datafield".  This is throwing off my AVG calculation.

      Important - I need to include the rest of the row, so I cannot exclude all data rows with a 999 in the "datafield"

       

      I am looking for a Formula which will average the "datafield", but exclude data in the average that has 999 in the "datafield".

      (I basically want a Formula that would include the "datafield" data in an Average if the "datafield" data is not equal to 999)