Lag calculation
The detailed planning Lag calculation takes a value from a predefined prior period and copies it into the current time period.
If the referenced prior period is outside the planning scenario time range, a NULL value is returned.
A typical use for this calculation is to calculate depreciation.
Parameters
- Source value: The source value for the calculation. The options are Calculation and Global Vector.
- Lag number of periods: The number of time periods before the current time period. The options are Value and Attribute (must be of type Double or Integer).
Examples
In the following example, the calculation has a lag of two time periods. Because the scenario starts in December, the first two lag months contain NULL.
| Dec | Jan | Feb | Mar | Apr | May | |
|---|---|---|---|---|---|---|
| Source value | 1 | 2 | 3 | 4 | 5 | 6 |
| Calculation Result | NULL | NULL | 1 | 2 | 3 | 4 |