6 Replies Latest reply: Oct 9, 2014 2:05 PM by Ashraf Muhammad Arsalan Ashraf RSS

    Currency convertion

      hi QV

       

      I have a requirement where I need to multiply the standard cost * exchrate(exch value should be based on max date),how should we achieve it in script level.

      Output looks like

      CurrencyStandardCost*excg(excg value should be based on max date)
      CHF0.25*1.2345
      EUR2.00*2.52356
      AFN0.56*0.2453

       

       

      INPUT table1:

      CurrencyStandard cost
      CHF0.25
      AFN0.56
      ALL1.56
      EUR2.00
      USD2.50

       

      table2:

      Currencyexch rateDate
      CHF1.234510/08/14
      CHF1.150314/08/13
      CHF1.22328/07/14
      EUR2.512315/07/14
      EUR2.5235602/08/14
      AFN0.234512/02/14
      AFN0.245328/02/14

      thanks