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.
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.
For example, you can use the ISACTUALVERSION function to ensure that a formula only applies to the Actual version.
ISACTUALVERSION()
The ISACTUALVERSION function does not use any arguments.
This function returns a Boolean result.
ISACTUALVERSION()
In this example, the formula returns a TRUE result for the version that is set as Actual.
Actual | Budget | Forecast | |
Actual version
|
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.