The ISACTUALVERSION function returns a TRUE result for the version that is set as Actual in a model. It returns FALSE for all other versions.
ISACTUALVERSION
For example, you can use the ISACTUALVERSION function to ensure that a formula only applies to the Actual version.
ISACTUALVERSION()
Arguments
The ISACTUALVERSION function does not use any arguments.
This function returns a Boolean result.
Syntax example
ISACTUALVERSION()
In this example, the formula returns a TRUE result for the version that is set as Actual.
| Actual | Budget | Forecast | |
Actual version
|
Examples
IF ISACTUALVERSION() THEN Sales.Year End Reports ELSE 0
In this example, the formula tests if a version is the Actual version. If it is, it returns the value of Sales.Year End Reports. If it is not, it returns 0.
Disclaimer
We update Anapedia content regularly to provide the most up-to-date instructions.