The ISCURRENTVERSION function returns a TRUE result for the version that is set as Current in a model. It returns FALSE for all other versions.
For example, you can use the ISCURRENTVERSION function to ensure that a formula only applies to the Current version.
Syntax
ISCURRENTVERSION()
Arguments
The ISCURRENTVERSION function does not use any arguments.
This function returns a Boolean result.
Syntax example
ISCURRENTVERSION()
In this example, the formula returns a TRUE result for the version that is set as Current.
| Actual | Budget | Forecast | |
Current version
|
Examples
IF ISCURRENTVERSION() THEN Sales.Year To Date Reports ELSE 0
In this example, the formula tests if a version is the Current version. If it is, it returns the value of Sales.Year to Date Reports. If it is not, it returns 0.
