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()
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.
