ISACTUALVERSION returns a TRUE result when the version coordinate of the current cell is the model's Actual version. Otherwise, it returns FALSE.
Syntax
ISACTUALVERSION()
Arguments
ISACTUALVERSION doesn't take any arguments.
This function returns a Boolean result.
Additional information
If Switchover is enabled, periods before the switchover date use values from the Actual version. This can affect results across time periods when using ISACTUALVERSION. For more information, see Switchover example in Versions.
Examples
IF ISACTUALVERSION() THEN Sales.Year End Reports ELSE 0
In this example, the formula checks whether the current calculation is using the Actual version. If it is, it returns the value of Sales.Year End Reports. Otherwise, it returns 0.
ISACTUALVERSION with Switchover
| Jan 23 | Feb 23 | Mar 23 | Apr 23 | ||
Is Actual?
| Actual | ||||
| Forecast |
Here, the switchover date is set for Mar 23. The Actual version always returns a TRUE result for all time periods. For the Forecast version, periods before Mar 23 are TRUE because they refer to the value of the Actual version. From Mar 23 onward, they're FALSE.
