Different formula for different selected version

Hi, I have 5 different versions in my model, Actual, High, Low, Mid, Budget Q and Budget FY.

I need to apply a lag a figure one month to the first 4 versions and for version Budget FY, I need to take the months value not the lag.

I have configured a custom versions module as well as attempted a boolean approach but am yet to get the desired result. Is there a way of selecting the following:

"If this version then this else do something else"

TIA

Accepted answers

All comments

luke_e

What are the dimensions of your versions module and your calculation module?

I'm assuming you're using native versions and your custom versions module is just by native version and a single line for the boolean?

We apply a similar concept in one of our models.

DavidFisher101

I have a version control module that I use in the if statement. I then applied the applies to version formula in the blueprint mode, but when I change that to applies to all version but actual then the formula breaks.

Is there a work around for this?

rob_marshall

@DavidFisher101

Try creating a CALC module that has all of the versions as line items. Then you can set these as a Line Item Subset (LISS). In the same module, create a subsidiary view (line item name will be Collect Data) with the same dimensions as the calc module, but also add the LISS, the formula should be Collect() and make sure you turn the summaries off.

In your control module, which I assume is a SYS Module for your versions, create a line item for the mapping to the LISS. Now, in your reporting module, you can do a sum on the mappinng: Calc Module.Collect[SUM:SYS Versions.Mapping]

Hope this helps.

Rob

luke_e

Depending on how many different calculation scenarios you have, the LISS solution from Rob might be easier.

It sounds like you have (2) scenarios, so either method should still work. Also, it's hard to tell from your explanation, but I would not be using 'Add Version Formula' function which appears under the 'Edit' menu in blueprint mode.

Assuming you stick with your current approach, your formula scope should still be set to 'All Versions'. I would expect your logic should look something like,

IF Settings Module.Use Custom Rule

THEN <Custom Rule>

ELSE <Default Rule>

There really shouldn't be much else to it beyond maybe optimising the calculation for the most frequent loop (e.g. is the custom rule applicable to more or less versions).

If you're sourcing actuals as well, it's just another loop to say 'IF Time Calculations Module.Actuals Period THEN ... ELSE ...

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!