The value in the last historical period.
N/A for all periods up to the last historical period.
For this formula and values:
v1000(@lasthist)
Table 2. @lasthist Sample Values and Formula
V1000 | 1998H | 1999H | 2000F | 2001F | 2002F | 2003F | 2004F |
|---|---|---|---|---|---|---|---|
Sales | 10 | 15 | 16.5 | 18.15 | 19.965 | 21.962 | 24.158 |
The formula returns and N/A in 1998, a 15.000 in 1999 and remaining periods.