Navigation:  MCL Reference > Statistics in a Race >

RunnersSum( )

Print this Topic Previous pageReturn to chapter overviewNext page

The RunnersSum( ) function returns the sum of a datum of all the runners in a particular race.

 

Syntax

RunnersSum('nValueExpr',cRaceID,'fCondition')

 

Argument

Description

Example

'nValueExpr'

Datum the sum of which is to be found.
Data type of expression: Numeric

'HrBodyweight( )'

cRaceID

Race ID (default to underlying race). Normally, this is a string returned by the functions HrRaceID( ), JrRaceID( ) and SrRaceID( ).

'17222'

'fCondition'

Logical expression to filter out a particular set of runners in the race.

'HrFP( )<=3'

 

Returns

The function returns a numeric value.

 

Examples

RunnersSum('Bodyweight( )')

Returns the sum of Body Weight of all the runners of the underlying race.

 

RunnersSum('Bodyweight( )','17222')

Returns the sum of Body Weight of all the runners of the race of ID '17222', i.e., the 222nd race of season 97-98.

 

RunnersSum('Bodyweight( )',,'HrFP( )<=3')

Returns the sum of Body Weight of the 3 fastest horses in the underlying race.

 

RunnersSum('Bodyweight( )','17222','HrFP( )<=3')

Returns the sum of Body Weight of the 3 fastest horses of the race of ID '17222', i.e., the 222nd race of season 97-98.

 

 


Page url: http://www.racematenet.com/english/help/index.html?runnerssum.htm