Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Best Regards,
Louis
In the attachment you can find a script with the example.
1. by default you can have only 5 currencies. if you need to add more, just put it to the inline load
2. AUD should always have all 5 rates
Hi,
how can you calculate the exchange rate ?
you should rather gather the exchanges rates and insert the values on your tables.. no ?
Hi youssef,
The exchange rate is provided in the excel file.
Some exchange rate are missing which i need to use other record to calculate.
For example:
the exchange rate from PHP to USD = the rate (PHP to AUD) * the rate (AUD to USD).
Best Regards,
Louis
Hi Louis,
It's possible if you always need to have the exact number of rates for each currency.
I mean 5 rows for AUD, 5 rows for PHP
In the attachment you can find a script with the example.
1. by default you can have only 5 currencies. if you need to add more, just put it to the inline load
2. AUD should always have all 5 rates
Thanks Tatsiana.
You give me a great help.