The AverageNZ( ) function returns the average of a set of values. Zero values will not be counted (You may pronouns NZ as No Zero). You may pass up to 27 arguments into the function.
Syntax
AverageNZ(x1,x2,x3,...)
x1, x2, x3,... must be numbers.
Returns
Numeric
Examples
AverageNZ(Column('This Rating'),Column('Last Rating'))
The average of the columns This Rating and Last Rating will be returned.
AverageNZ(2, 0, .Null., 4)
3 will be returned by the above function (average of 2 and 4). Both 0 and .NULL. are ignored.
Page url: http://www.racematenet.com/english/help/index.html?averagenz.htm