RUNNINGPROD
Category: Rollforward & time series
Overview
Description | Calculates the cumulative product of a node along the time axis. Use when you need to accumulate multiplicative effects over time, such as chained growth factors. |
|---|---|
Syntax |
|
Parameter | Node: Input node, specified using the node name in single quotes (e.g. |
Examples
Cumulative product over time
This example shows how RUNNINGPROD multiplies each value by all previous values along the time axis.
Input node: Profit
Year | Value |
|---|---|
2025 | 1.1 |
2026 | 1.2 |
2027 | 1.2 |
Formula: RUNNINGPROD('Profit')
Year | → RUNNINGPROD Result |
|---|---|
2025 | 1.1 |
2026 | 1.32 |
2027 | 1.584 |
Related Functions
Function | When to use instead |
|---|---|
When you need additive accumulation over time instead of a cumulative product. | |
When you need multiplication across discrete integer steps rather than a running product over a time series. |