SumTableColumn

This function evaluates to the sum of a table slot’s values, in the given column, from the given start row to the given end row.

Description

Sum of the values of a table slot column between two rows.

Type

NUMERIC

Arguments

Type

Meaning

1

SLOT

the table slot whose values to sum

2

NUMERIC

column

3

NUMERIC

start row

4

NUMERIC

end row

Evaluation

The function loops over each value in the given column of the given table slot, beginning with the start row and ending with the end row (inclusive). Each value is added to the previous sum. The function evaluates to this sum. Rows and columns are numbered beginning with zero.

Mathematical
Expression

 

 

 

Comments

Units are not required for row and column indices and, if provided, will be ignored. If the column, start row, or end row do not exist in the slot or if the start row is greater than the end row, this function aborts the run with an error. If one of the slot values within the desired time range is a NaN, the function exits the rule with an early termination.

 
SumTableColumn(Chickamauga Data.Flow, 0, 0, 1)
 
13.95