Skip to Content
BooksFP&AChoosing forecast drivers

Choosing forecast drivers

A forecast driver supplies amounts for an account over a selected range of future periods. Open an account’s actions in an FP&A forecast to create or modify one.

Set the period range

Choose From and To. When the account has several gaps between existing drivers, use Open Range to select the gap you want. Shorten the range to reserve later periods for a different rule.

A driver cannot overlap another driver on the same account or replace actual periods. If every future period is covered, modify or remove an existing driver first.

Annual Target

Enter Annual Target and choose Spread Method. Evenly spreads the remaining target across open periods in the current year. Trend uses the selected historical pattern; choose Trend Source and, for Custom Year Data, the years to use.

The calculation subtracts the account’s year-to-date actual amount from the target. For forecasts extending into later years, it repeats the current year’s account pattern into the corresponding periods. Review that behavior before using this driver for a growing multi-year plan. For a Yearly forecast, the first future year receives the full target, which then repeats into later years.

Average Trend

Select historical periods from the current year, a past year you add, or both. Review the displayed average. That average becomes one repeated amount for every forecast period in the selected range.

Only periods with available historical data contribute meaningfully to the comparison. Check the chosen year and period values before saving.

Amount per Headcount

Choose Hourly Based or Fixed. In hourly mode, enter working hours, days, employees, and hourly rate for each row. In fixed mode, enter employees and average cost. Review each row’s total and the combined amount.

The combined amount repeats across the selected periods. Set inputs at the same frequency as the forecast; a monthly staffing assumption is not automatically an annual total.

Growth on Historicals

Choose a historical basis and enter Annualized Growth Rate.

BasisWhat you select
Year over YearThe number of years back for the corresponding historical period
Average (Calendar)A fixed historical year and selected periods to average
Average (Rolling)A rolling window of prior periods

The rolling average moves forward with each period and can include earlier forecast results once it passes the actual periods. Review the historical selection and preview before saving.

Periodic Growth

Choose Starting From → Enter Amount for a typed base amount or Select Period for an average from historical periods. Choose the growth type and enter the rate or amount per period.

Each following period grows from the preceding forecast period. Review the base and first-period preview to distinguish a repeating amount from a compounding forecast.

% of Another Account

Choose Reference Account / Metric and enter Percentage. Available references include profit-and-loss accounts and totals, balance-sheet accounts and totals, and custom variables.

The driver applies the percentage to the selected reference for the forecast periods. Check that the reference is available and represents the quantity you intend to model.

Manual Entry

Enter an amount for each open period in the selected range. Actual periods are read-only. This driver uses the values you enter rather than calculating a spread or growth rate.

Review every open period before saving. As periods become actual, those periods lock to their actual values while remaining future entries stay available.

Custom

Enter the custom metric’s Name and Units, then build a formula with the available variables, constants, operators, and parentheses. Review the formula before saving.

The formula is evaluated for each forecast period; its result is not divided across the range. The custom metric also appears in FP&A → Metrics, where it can be inspected and reused.

Save and review

Click Create Driver for a new rule or Save Changes for an existing one. Confirm the period range shown in the account’s menu and inspect the recalculated statement. Correct missing references or invalid inputs when the form reports an error.

Last updated on