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

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


      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!!!