Hello Friends
I have a requirement that must convert an amount into USD and remain constant.
Let me illustrate it further with an example
The column INR Cost Inc Mark Up is in Indian Rupee
This column must be converted into USD.
It must be converted based on the SPOT RATE for the day. Once calculated, the value can only change the next day because SPOT RATE is likely to change only on a daily basis
Kindly help.
Regards
Bobji
INR '000 Billing FTM | INR '000 Markup @ 15% | INR Cost Inc Mark up | Cost USD |
5,816 | 872 | 66,88,339 | |
831 | 125 | 9,55,563 | |
1 | 0 | 1,472 | |
110 | 16 | 1,26,267 | |
- | - | - | - |
6,728 | 1,009 | 77,37,112 | |
802 | 120 | 9,22,241 | |
4,237 | 636 | 48,72,734 | |
9 | 1 | 10,345 | |
2 | 0 | 2,170 | |
279 | 42 | 3,20,919 | |
|
You need to bring in the spot rate, using the append field tool, and then depending on which way the spot rate is going divide or multiply the cost inc mark up
Hi @aatalai
How do I bring in the spot rate? It is available in the company website. How do I capture that value?
@BobjiK can you use an api/the download tool?
what website are you using
It is an internal company website.
that might be tricky, but try this put the URL into a text input tool and connect that to the download tool, and see what you get
Would you mind sending a sample WF?
@BobjiK take a look at this, you would still need to parse the data afterwards