ITEM(Versions) : Versions is not recognized as a hierarchy in the model

PrevContributor

Good afternoon, I recently worked with the IF ITEM(Hierarchy) = Hierachy.HierachyItem THEN ... ELSE ... to aggregate calculation modules. Currently I want to do the same for the different calculations I made regarding actuals, forecasts, budgets on bases of input files. However, when using the formula: IF ITEM(Versions) = Versions.Actual THEN ... ELSE ... I receive this error : Versions is not recognized as a hierarchy in the model , however it is added to the module, as shown below. Is there another formula specific to Versions, or does Anaplan not allow for these if functions? Thanks!

Capture001_966.PNG

peter_mcanena

That's right - the ITEM() and FINDITEM() functions don't work on the Versions list. You have a few other functions that you might be able to use instead: ISCURRENTVERSION() and ISACTUALVERSION(). You can also use PREVIOUSVERSION() and NEXTVERSION() to write some logic that identifies the first and last versions in the version list. Some of that may help.

Otherwise, if you really need to write custom logic depending on the version, you can get round it with an input module that's fully versioned, and using that to flag up which behaviour you want in each version. Here's one way to do this:

• Add a module called Version-Specific Behaviour, with versions set to All
  
• Put a line item in Version-Specific Behaviour called Sample Flag, formated Boolean. Don't put a formula in this line item
  
• You can now say IF 'Version-specific Behaviour'.Sample Flag THEN ... ELSE ... and you just tick the sample flags in Version-Specific Behaviour for the versions you want