17 Replies Latest reply: Jul 11, 2017 11:58 AM by Amit Saini RSS

    Currency help based on Selection

    Amit Saini

      Hi Folks,


      I'm having currency Table like below:



      PlantJan FebMarApr


      For Plant A exchange rates are .0123 for Jan , .0124 for Feb and so on...


      Now if I select any one Month , then my result is working fine.


      Suppose I select Multiple Months say Jan , Feb , Mar


      Then Revenue should be multiply with Mar Exchange Rate, in case if I  select Mar and Apr together then exchange rate should be from Apr.

      So we have to take always the latest Month as per selection.


      I'm not sure ,how this can be achieved , please help!


      My expression is = Sum(Revenue)*Exchange_Rate