SELECTING Current Version

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?

Accepted answers

PrevContributor

Yes, you can use the ISCURRENTVERSION calculation function to do this. See https://community.anaplan.com/anapedia/calculation-functions/iscurrentversion for more information on this function.

All comments

PrevContributor

Yes, you can use the ISCURRENTVERSION calculation function to do this. See https://community.anaplan.com/anapedia/calculation-functions/iscurrentversion for more information on this function.

PrevContributor

Sebastian, did you try Heather solution?

sebastian

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

For example.
There is an existing function [SELECT" VERSIONS.'Actual']. Similarly having [SELECT: VERSIONS.'Current'] where "Current' being a reserved keyword.

rgds
Sebastian

PrevContributor

Hi Sebastian,

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.

Best,

Hilary

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…