Skip navigation
Currently Being Moderated

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

Aug 14, 2012 2:38 PM

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

  • Currently Being Moderated
    Aug 14, 2012 3:06 PM   in reply to LuckyLady83

    If you use the calculation option "The field is the ____ of the following fields:", nulll values and zero values are included as zero and the number of number of items use is the number of fields selected.


    If you want a different calculation, then you will have to write a custom script to sum and count the fields you want to include in the calculation.

    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points