This set of functions is similar to the HrAverage( ) function set. However, these functions will skip items with values 0 and Null. (NZ stands No Zero)
Syntax
HrAverageNZ('nValueExpr',nRaces,'fCondition',nDefaultValue,cIncluding)
JrAverageNZ('nValueExpr',nRaces,'fCondition',nDefaultValue,cIncluding)
SrAverageNZ('nValueExpr',nRaces,'fCondition',nDefaultValue,cIncluding)
Argument |
Description |
Example |
||||||||
'nValueExpr' |
|
'HrDvdWin( )' |
||||||||
nRaces |
|
6 |
||||||||
'fCondition' |
|
'For HrFP( )=1 While HrDate( )>Date(1999,9,1)' |
||||||||
cDefaultValue |
Default value returned when no race satisfying the specified condition can be found. The data type of this value must be identical to that of normal return value. |
|||||||||
cIncluding |
When applying the function to past records, by default, races in the underlying meeting are not included. You may use this argument to change the scope. See the following page for details: The cIncluding Argument. |
'R' |
Returns
Numeric
See Also
HrAverage( ), JrAverage( ), SrAverage( ) | HrAverageBy( ), JrAverageBy( ), SrAverageBy( )
Page url: http://www.racematenet.com/english/help/index.html?hraveragenz.htm