Spread data calculation
The detailed planning Spread data calculation spreads data to months and creates vector values.
The months that receive data from the spread is based on the start and end periods; therefore, if the spread only affects 12 months, the start and end periods must be set accordingly. The calculation functions as follows:
Result(x) = Source_Month(x) * (Spread(x) / Sum(Spread(x))
Tip: The Spread data calculation is the opposite of the Accumulate calculation, in that it takes an aggregate amount and divides it into monthly amounts.
Parameters
- Source value: Select Value to enter a numeric value; selecting any of the others presents a list of the currently defined objects of that type.
- The options are Value, Attribute, Calculation, Global Vector.
- Spread factor: How the calculation spreads the data, and is not adjustable.
- The options are Spread Evenly, Calculation, Global Vector.
- Spread range: How far in time the spread runs.
Spread to full calculation range
The spread uses the pre-defined range.
Spread to full detailed planning object time range
The spread is for the time range bounded by the Start period and End period of the DPO.
Spread within each calendar year
Default; the spread is for the calendar year rather than the fiscal year.
Spread within each fiscal year
The spread is by the fiscal year rather than calendar year.
Spread within each fiscal quarter
The spread is made evenly for each fiscal quarter.
Examples
Source value is set to a numeric attribute and the calculation affects only three months
| Jan2018 | Feb2018 | Mar2018 | |
|---|---|---|---|
| Source value | 12 | 12 | 12 |
| Spread factor | 3 | 2 | 1 |
| Calculation Result | 6 | 4 | 2 |
Source value is set to a calculation and varies monthly
| Jan2018 | Feb2018 | Mar2018 | |
|---|---|---|---|
| Source value | 12 | 24 | 6 |
| Spread factor | 3 | 2 | 1 |
| Calculation Result | 6 | 8 | 1 |