Description
Returns the value of the previous cell in the iteration Dimension of the base Metric, as defined in the iterative calculation configuration.
This function allows you to create multi-Metric iterative calculations.
For more information on how to create iterative calculations, see Iterative Calculation & Circular Referencing.
Syntax
PREVIOUSBASE()Arguments
Not applicable.
Returns
| Type | Dimensions |
|---|---|
| Same as the Base Metric | Same as the Base Metric |
Examples
| Formula | Description |
|---|---|
PREVIOUSBASE() | Returns the previous month value of the Base Metric with Month selected as Iteration Dimension. |
Equivalent in Pigment: 'Base Metric'aSELECT: 'Iteration Dimension' - 1]
See Also
Excel: no equivalent
Related articles: