Using different versions in formula

hinamahmood1994

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. 

 

DavidSmith

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

rob_marshall

@hinamahmood1994 ,

 

Can you not use the function previousversion()?  https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/PREVIOUSVERSION.html

 

Rob

hinamahmood1994

Hiya, 

 

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