Is there a way to not include zero values in sums and an average?
i'm working on new performace evaluation & sum score of each line, average of total scores.
example: stength (1 value), solid performer (2 value), performer (3 value), recommend development (4 value), n/a (zero value) total score of values, not including 0 value.
then average score of scores given.
hope makes sense!
thanks in advance input!!!
if use calculation option "the field ____ of following fields:", nulll values , 0 values included 0 , number of number of items use number of fields selected.
if want different calculation, have write custom script sum , count fields want include in calculation.
More discussions in JavaScript
adobe
Comments
Post a Comment