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 involving multiple Blocks, see Iterative Calculations Across Multiple Blocks using PREVIOUSBASE.
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'BSELECT: 'Iteration Dimension' - 1]
See Also
Excel: no equivalent
Related articles:
- Iterative Calculations Across Multiple Blocks using PREVIOUSBASE
- PREVIOUS function
- Iterative Calculations Within a Block Using PREVIOUS