5 Replies Latest reply: Dec 20, 2017 9:12 PM by Louis Lam RSS

    Generate missing Exchange Rate

    Louis Lam

      Hi all,

       

      I have an exchange rate table.

      However, some of the records are missing and i have to calculate the missing records.

      For example:

      I need to calculate the exchange rate from PHP to USD.

      What i need to do is using the rate (PHP to AUD) * the rate (AUD to USD).

      Is it possible to generate all cases like (MMK to USD) by scripting?

      Capture.PNG

       

      Best Regards,

      Louis