SELECTING Current Version

sebastian
sebastian
in Modeling

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?

Tagged:

Best Answer

Answers

  • PrevContributor
    PrevContributor
    Sebastian, did you try Heather solution?
  • sebastian
    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
    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

Categories