@histavg or @histavg(vXXXX)

Definition

Historical forecasting average

If a Freeform Formula forecast method contains @histavg, no input is required in the forecast period. On the Accounts view, when the cursor is on the referenced account, the Hist. Avg. text box displays the historical average.

The years in the calculation of the historical average are defined in Defining, Deleting, and Displaying Time Periods.

Returns

The historical average based on the forecasting method used in the account.

Example 1

The basic formula:

@histavg

Example 2

If Sales (v1000) in 2006 and 2007 are 10 and 12, and the forecasting method of sales is as an actual dollar value, this formula:

@histavg(v1000) 

returns 11.

Example 3

If example 2 uses a growth rate forecasting method, Strategic Finance calculates the historical average at 20%—the growth rate needed to get from 10 to 12.