RUNNINGSUM

Category: Rollforward & time series

Overview

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

Each period’s value equals the sum of all values from the first 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(Node)

Example usage

RUNNINGSUM('Profit')

Parameter	Description	Type	Required
Node	Input node, specified using the node name in single quotes (e.g. `'Profit'`)	Node reference	Yes

Aspect	Behavior
Dimensionality	Preserves the input shape
Row count	Same number of rows as the input node
Time axis	Each period accumulates all preceding values
Non-time dimensions	Running sum is calculated independently for each combination

RUNNINGSUM requires a time dimension in the input node.
The cumulative calculation follows the chronological order of the time hierarchy.
Each combination of non-time dimensions is accumulated independently.

Input node: Profit

Formula

RUNNINGSUM('Profit')

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.

Function	When to use instead
RUNNINGPROD	Cumulative multiplication along the time axis instead of summation.
MOVINGSUM	Calculates sums over a sliding window of periods.
MOVINGAVG	Calculates averages over a sliding window of periods.
ROLLFORWARD_ADVANCED	Project values forward in time.