RUNNINGSUM

In Rollforward & time series

The RUNNINGSUM function calculates a cumulative total along the time axis.

Each period’s value equals the sum of all values from the first non-empty period up to and including the current period.

Use this function when you want to track how values accumulate over time or as a helper function: RUNNINGSUM('Profit').

Parameters

NodeNode referenceRequired

Input node, specified using the node name in single quotes (e.g. 'Profit')

Output shape

Dimensionality

Preserves the input shape

Row count

Same number of rows as the input node

Time range

Each period accumulates all preceding values

Non-time behavior

Running sum is calculated independently for each combination

Watch out

Examples

Basic cumulative total

Input node: 'Profit'

Formula: RUNNINGSUM('Profit')

Multi-dimensional input

When the node has additional dimensions (e.g. Region), the running sum is calculated independently for each dimensional combination.

Input node: 'Revenue'

Formula: RUNNINGSUM('Revenue')

Each region accumulates its values independently over time.

Behavior with gaps in the data

When the input has missing values for some time periods, RUNNINGSUM skips leading empty periods and treats later gaps as zero.

Input node: 'Payments'

Formula: RUNNINGSUM('Payments')

2024 is omitted from the output because it is a leading empty period. 2026 has no value, so it is treated as zero, the running total carries forward unchanged.

See also

YTD

When you need running totals that reset within each year.

RUNNINGPROD

When you need cumulative multiplication along the time axis.

MOVINGSUM

When you need a sum over a sliding window instead of from the start.

MOVINGAVG

When you need an average over a sliding window instead of a cumulative total.

ROLLFORWARD_ADVANCED

When you want to project values forward in time.