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