CAS 6


cumtotal
- Sequential

Summary

Calculate cumulative total subject to ordering and grouping.

Examples

cumtotal PRINC
cumtotal 10 25 14

Syntax

cumtotal NumField (Selection|Order (Grouping[Selection))

Right Arguments

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

Result

Type: Numeric

Cumulative Total



Build 6.0.624