The above functions are similar to functions HrAverage( ), JrAverage( ), and SrAverage( ) except:
1. | If the number of races meeting 'fCondition' is smaller than nRaces, the function will return .NULL. |
2. | Although the functions accept 5 arguments, the 4th argument of HrXAverage( ), JrXAverage( ), SrXAverage( ) will always be ignored. |
Syntax
HrXAverage('nValueExpr',nRaces,'fCondition',nDefaultValue,cIncluding)
JrXAverage('nValueExpr',nRaces,'fCondition',nDefaultValue,cIncluding)
SrXAverage('nValueExpr',nRaces,'fCondition',nDefaultValue,cIncluding)
Argument |
Description |
Example |
||||||||
'nValueExpr' |
|
'HrDvdWin( )' |
||||||||
nRaces |
|
6 |
||||||||
'fCondition' |
|
'For HrFP( )=1 While HrDate( )>Date(1999,9,1)' |
||||||||
nDefaultValue |
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
Examples
HrXAverage('HrWeight( )',3)
The above example returns the average loading of the past 3 races of the horse.
HrAverage('HrSpeed( )',4,'For HrDistance( )=1400')
The above example returns the average speed of the last 4 1400m races of the horse.
HrXAverage('HrSpeed( )',,'For HrDistance( )=1400 and HrAveRating( )>100')
The above example returns the average speed of all races meeting the following conditions:
1. 1400m race
2. Average rating of the race is greater than 100
Page url: http://www.racematenet.com/english/help/index.html?hrxaverage.htm