SumSlot and SumSlotSkipNaNs

This function sums a series slot’s values between a starting timestep and ending timestep.

Description

The sum of a slot’s values over time.

Type

NUMERIC

Arguments

Type

Meaning

1

SLOT

the series or periodic slot to sum

2

DATETIME

the start date

3

DATETIME

the end date

Evaluation

The function loops through all of the slot values between the start and end datetime arguments. Each value is added to the previous result.

Mathematical Expression

 

Comments

If the starting or ending datetime argument is not defined in the series slot, this function aborts the run with an error.

For the SumSlot function, if one of the slot values in the time range is a NaN, the function forces an early termination of the calling rule. The "SkipNaNs" variation treats an invalid value (NaN) as 0.0.

For periodic slots, the dates used are those in the first column within the range and falling on a run timestep.

 
SumSlot(Crystal.Inflow, @"January 1, 1999", @"September 30, 1999")
 
32.47 "cms"