Budget vs Forecast Version

Olek P

Hi,

I have multiple versions in my model. (Actual, Budget, Forecast, Scenario 1)

I was wondering about the best way (best practice) of pulling in values for one version, else formula.

For example:

IF version = Budget Then valuex ELSE formula

I was wondering what the actual syntax would look like. I don't know how to make it work.

Question 2,

If I want to do multiple versions I would need an if statement for each version?

Thx

Comments

willridge

If you're using Anaplan Versions then you might be able to use things like ISACTUALVERSION() AND ISCURRENTVERSION for part of the formula, e.g IF ISACTUALVERSION() THEN ACT01.Actual ELSE IF ISCURRENTVERSION() THEN BUD01.Values ELSE PLA01.Current plan values

Alternatively, you can set up a Version systems module (e.g VER01) where you have a boolean line item for each Version, and do something like IF VER01.Budget? then BUD01.Values ELSE IF VER01.Forecast? THEN PLA01.Current Plan Values, etc etc

If you're not using Anaplan Versions then please let us know as the solution would be different

Olek P

I did make it work with your second solution there. (The version module) Thank you.

I am curious as to what another solution would be. Could you elaborate on that point @willridge ? If I was not using Anaplan versions, what would the solution look like?

Thank you

willridge

@Olek P the alternative would be to use a list of Versions, where you could use Lookups or mappings in the formulas.

There's a good article here that explains the options:

https://community.anaplan.com/discussion/51410/oeg-best-practice-to-version-or-not-to-version

Quick Links

New ideas

Grouping Modules or Module Folders
We got several hundred of modules. I think it could be usefull if modules can get sorted/filtered by (dynamic) groups or even in folders in the modules overview. Maybe the Data Tags could used with this. //GP
Enable Selective Access in Manual Filtering data
Selective Access for list used as a format of line item works properly when given line item is published on dashboard or page. Unfotunatly if user wants to filter data manually, he/she is able to see all items from the list. This behaviour was observed on dashboards and in NUX as well. This issue is most troublesome for a…
Export Function in Anaplan Beta Version – Feedback / Observation
While working in the Beta version of Anaplan, we’ve noticed that the Export button is unavailable when switching to the Beta environment. This limits our ability to export required data directly from modules. When the Export button is available, it works as expected — allowing us to export necessary data such as items used…