Using different versions in formula

Contributor

Using different versions in formula

Hi, 

 

I'm trying to create a formula that has 2 different views of forecasts. My current and my previous. Current is pulling in fine. Struggling to create a formula that says Fcst V2 = Previous months Forecast. So if Current forecast is p4. I want my FCST V2 to equal my p3 Current forecast. 

 

Message 1 of 4
3 REPLIES 3
Community Boss

Re: Using different versions in formula

Message 2 of 4
Highlighted
Contributor

Re: Using different versions in formula

Hiya, 

 

So that won't work because my master module source doesn't include versions. 

Message 3 of 4
Community Boss

Re: Using different versions in formula

Set up a module dimensioned by you "versions" list and create Boolean line items for each, so effectively it is Versions by Versions

Tick each versions against each one, so effectively you have a "diagonal" set of tick boxes

Then in you target formula you can refer to this module:

 

IF version mapping.IsversionFcst2? then else IF version mapping.IsversionPrevFcst then ..,. etc.

 

Does that make sense?

David

Message 4 of 4