@isfirstfore

Definition

Is the first forecasted period in the model

A relative reference in @if statements, enabling you to change the historical/forecast boundary and maintain the integrity of the formula. Forecast periods are determined by the historical/forecast boundary set in Defining, Deleting, and Displaying Time Periods.

Returns

  • True—if the period is the first forecasted period in the model

  • False—if not

Example 1

If a model is in years and the historical/forecast boundary is 2007/2008, with 2008 as the forecast period, this formula:

@if(@isfirstfore,1,2)

returns 1 for 2000, and 2 for other periods.

Example 2

The same formula in the previous example, but with a model in quarters with the first quarter of 2008 as the first forecast period, returns 1 for the first quarter of 2008, and 2 for other periods.