Is it possible to SELECT current version For example, instead of coding [SELECT: VERSIONS.Forecast3] where Forecast3 is my current forecast and Forecast3 gets hardcoded in the formula. Can I code something like [SELECT: VERSIONS.CURRENT] or something similar?
Hi Daniel and Heather.
Yes I tried.ISCURRENTVERSION works fine for what it was meant for (for a boolean result).
However I was wondering if I can have it in SELECT/LOOKUP function
There is an existing function [SELECT" VERSIONS.'Actual']. Similarly having [SELECT: VERSIONS.'Current'] where "Current' being a reserved keyword.
While I'm not sure how your model is set up, Heather's suggestion to use the ISCURRENTVERSION function to return the current version results can be used in a variety of ways besides a true/false boolean answer. For example if you want to bring your forecast3 revenue number in from another module and you are using versions in your target module - you could say IF ISCURRENTVERSION THEN SOURCE MODULE.'SOURCE LINE ITEM' ELSE 0.
Alternatively, if you are not using versions in your target module, you can just not include a version select statement in your formula because Anaplan defaults to select the current version when a version is not specified.