NumAvg
Returns the numeric average of 1 to N arguments. If no numeric value is found, NULL is returned.
Information noteThe numavg function has been superseded by the RangeAvg - script and chart function function. Although numavg can be used, it is not recommended.
Syntax:
NumAvg(expr1 [ , expr2, ... exprN ])
Examples and results:
- numavg( 1,2,4 ) returns 2.33333333
- numavg( 1,'xyz' ) returns 1
- numavg( null( ) 'abc' ) returns NULL