Skip navigation
LuckyLady83
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!!!

 
Replies
  • 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