This set of functions is similar to the HrCount( ) function set. However, these functions will skip items with values Null and empty values (0, empty string or empty date etc). (NZ stands for No Zero)
Syntax
HrCountNZ('lCountIf',nRaces,'fCondition',nDefaultValue,cIncluding)
JrCountNZ('lCountIf',nRaces,'fCondition',nDefaultValue,cIncluding)
SrCountNZ('lCountIf',nRaces,'fCondition',nDefaultValue,cIncluding)
Argument |
Description |
Example |
||||||||
'lCountIf' |
|
'HrFP( )=1' |
||||||||
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
HrCountNz('HrRating( )>80',6,'For HrDistance( )=1400')
HrCount('HrRating( )>80',6,'For HrDistance( )=1400')
The above 2 examples will return exactly the same result.
HrCountNz('HrRating( )',6,'For HrDistance( )=1400')
The above example returns the number of 1400m starts, in which HrRating( ) returns a non-null and non-zero value, in the past record of the horse. If total number of races is greater than 6, the function will return 6 instead of the actual number. Please note that starts will NOT be counted if HrRating( ) returns 0.
See also
HrCount( ), JrCount( ), SrCount( )
Page url: http://www.racematenet.com/english/help/index.html?hrcountnz.htm