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.


ActualBudgetForecast

Actual version

ISACTUALVERSION()



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.