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

Popular posts from this blog

How to change text Component easybook reloaded *newbee* - Joomla! Forum - community, help and support

After Effect warning: A problem occurred when processing OpenGL commands

Preconditions Failed. - Joomla! Forum - community, help and support