9 Replies Latest reply: Jul 13, 2012 12:09 PM by Felim Shanaghy RSS

    Averages - excluding 'blank' or 'N/A' entries

    Michael Stevens

      Hello,

       

      I am attempting to generate Average expressions, but I am currently experiencing difficulty in excluding entries where '0's, 'blanks' or 'N/A's appear.

       

      Is there a way in which this can be embedded within the standard Average expression?  If so, how do I go about achieving this please?

       

      Thanks and regards, Mike.