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 | |
| | | |
