Need to lock a currency for a certain scenario and period.
Hi, I have a PnL with different scenarios for forecasting and with consolidation in to a single currency with revenue in different currencies.
I have already implemented that you can choose which currency to map with A (Actuals FX Rates) and B (Budget FX Rates) but know I need to add a third option which would be N. What N should do is take the currency valid for the period where its inserted and apply that to the rest of the years coming periods.
That means that for scenario1 it should be 1,323500 from march and the rest of 2015.
For Scenario2 it should be 1,354995 from May and until the rest of 2015. I've tried with a few intern() combined with if conditions in the script but can't really get it to work.
Thankful for any help
I've attached an example file in Excel that explains a bit better what I'm trying to achieve.