Lead calculation
The detailed planning Lead calculation takes a value and applies it to a specified number of future time periods.
Lead calculations are useful in forecasting applications, such as determining the number of people to hire (headcount) based on future expected billable revenue, or the amount of goods to purchase to replenish inventory.
If the number of lead periods is beyond the time range of the scenario, a NULL value is returned.
Parameters
- Source value: The options are Calculation and Global Vector.
- Lead number of periods: The number of time periods after the current time period. The options are Value and Attribute (must be of type Double or Integer).
Example
In the following example, the calculation has a lead of two time periods. Because the scenario ends in May, the last two lag months contain NULL.
| Dec | Jan | Feb | Mar | Apr | May | |
|---|---|---|---|---|---|---|
| Source value | 1 | 2 | 3 | 4 | 5 | 6 |
| Calculation Result | 3 | 4 | 5 | 6 | NULL | NULL |