Navigation:  MCL Reference > Arithmetic Functions >

AverageNZ( )

Print this Topic Previous pageReturn to chapter overviewNext page

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