3 Replies Latest reply: Jun 29, 2015 3:16 PM by Sunny Talwar RSS

    Need to lock a currency for a certain scenario and period.

    Andreas Gumaelius
      PeriodScenario1Scenario2
      201501AA
      201502AB
      201503AN
      201504N
      201505

       

      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.

       

      PeriodFXRate
      201501

       

      1,268000
      201502

       

      1,117393
      201503

       

      1,354995
      201504

       

      1,323500
      201505

       

      1,357140