Skip navigation
LuckyLady83
LuckyLady83 Calculating status...
Currently Being Moderated

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

Aug 14, 2012 2:38 PM

Categories: Windows

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

263 Views   2 Replies   Latest reply: LuckyLady83, Aug 15, 2012 12:04 PM
 
Replies
  • GKaiseril
    Currently Being Moderated
    1. GKaiseril,
    Aug 14, 2012 3:06 PM   in reply to LuckyLady83
    Report

    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:
  • LuckyLady83
    Currently Being Moderated
    2. LuckyLady83,
    Aug 15, 2012 12:04 PM   in reply to GKaiseril
    Report

    Thanks for the replay, GKaiseril.  I didn't want the zero's in there.  I was hoping for some help with the script.  I'm not all that familar with JS.

     
    |
    Mark as:
Actions

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