Calculate cumulative total subject to ordering and grouping.
cumtotal PRINC
cumtotal 10 25 14
cumtotal NumField (Selection|Order (Grouping[Selection))
Name | Data Type | Input Type | Description | Optional | Default |
---|---|---|---|---|---|
NumField | Numeric | Field | Numeric field to sum on | No | |
Order | Numeric | Field | Ordering | Yes | |
Grouping | Text | Field | Grouping | Yes | |
SelectionStatement | Boolean | Field | Expression to select records that will be applied to the calculation. | Yes | 1 |
Type: Numeric
Cumulative Total