2 Replies Latest reply: Aug 15, 2012 12:04 PM by LuckyLady83 RSS

    Is there a way to not include zero values in sums and an average?

    LuckyLady83

      I'm working on a new performace evaluation & would like to sum the score of each line, then get an average of the total scores.

       

      example:  stength (1 value), Solid Performer (2 value), Performer (3 value), Recommend Development (4 value), N/A (zero value)  then a total score of all the values, not including the zero value. 

       

      Then an average score of all the scores given.

       

      Hope this makes sense! 

       

      Thanks in advance for the input!!!