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
      A0.01230.01240.01250.0126
      B1234
      C0.10.20.30.4

       

      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

       

      Regards,

      Amit