Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have table in that table one field called money.the money field having Indian currency.I want change Indian currency to Us currency
in script level it self and i dint want to change in UI level then the UI level it has so show US currency.Is there any function to do this.
Thanks.
When you load the table..you can change money field as below
MoneyField/45 as [MoneyFieldin USD]
Change 45 as per the conversion rate
Hi,
For Conversion of Currency you need conversion table where you can map your Indian Currency to US Currency.
Regards,
something like that:
SET vIndToUSDollar = 0.016;
Data:
LOAD *,
Value * $(vIndToUSDollar) as Value_in_USDollar
;
LOAD * INLINE [
ID, Value
1, 10
2, 50
3, 100
4, 40
5, 35
];