Allocate deficits to meet targets
After a forecast is defined, actuals may fall below the forecast. The shortfall between the forecasted and actual values is called the deficit.
If the forecast represents a committed target (quarter/year), a shortfall in early periods needs to be recovered later to still meet the target total.
Without distribution, the total forecast drifts downward unless someone manually adjusts later periods.
With distribution, Plan shifts the shortfall to remaining periods so the overall target remains consistent.
Distribute deficits
Select a forecast cell, then select Distribute Deficit.
Distribute a deficit to the total cell to adjust the overall total, or distribute it to child cells to spread the adjustment across lower-level forecasts.
Select the measure to compare the forecast against. The deficit is automatically calculated and displayed.
If you have multiple forecast measures in your report, select the forecast measure to distribute the deficit.
Select the calendar icon, then select the periods to distribute the deficit across.
Select the Distribution Method: distribute the deficit equally or by the weights of the forecast.
Select Run to distribute the deficit across the selected periods.
Last updated
Was this helpful?