We have updated the syntax for cumulative calculations on variables to make it simpler and more consistent.

What’s new?

We have replaced the CUMSUM (Variable, criteria*) function with a new, simplified syntax using time modifiers. No action is required — all existing formulas have been automatically migrated to the new syntax.

Why this change?

This update simplifies expressions, improves readability, and aligns cumulative functions with other time-based modifiers.

New syntax

Use the following modifiers to calculate cumulative values:

Quarter-to-date (QTD)

• Before: CUMSUM (Variable, quarterly)
• Now: Variable.QTD

Year-to-date (YTD)

• Before: CUMSUM (Variable, yearly)
• Now: Variable.YTD

All-time cumulative

• Before: CUMSUM (Variable)
• Now: Variable.AllTime

Learn more about time modifiers here: Filters, time modifiers, and conditionals.