How to convert the currency in USD based on the different FX rates

[Koyel Guha]

Hi, 

I have a requirement on currency conversion in USD , we will enter amount in variable "Amount in LEC" (single line text) and will select currency(AUD ,EUR etc as mentioned below) so, user will add amount like 1000,200.50 etc and fx currency then amount will convert in USD and populate in new variable "Equivalent in USD".. Below is the screenshot for ref. Please help me how to fulfill this requirement. 

      

Name	Currency	US$ per LC
Australian Dollar	AUD	0.72000
Canadian Dollar	CAD	0.75188
Euro	EUR	1.10000
British Pound	GBP	1.21000
Polish Zloty	PLN	0.22173
Singapore Dollar	SGD	0.74627

Thank you

[AshishKM]

Hi @Koyel Guha , 

The second field can be use the calculated value or you can write onChange script and read the  FX rate from the table and calculate the value for ""Equivalent in USD".

Share some code or screen shot from dev.

-Thanks,
AshishKMishra

[Koyel Guha]

Hi Ashish,

I could see there are few entries in fx rate table. However, I need to use the excel below . Do I need to add these records in the fx rate table. I have not developed any script yet.

Can you please help me with the steps to develop this

Name	Currency	US$ per LC
Australian Dollar	AUD	0.72000
Canadian Dollar	CAD	0.75188
Euro	EUR	1.10000
British Pound	GBP	1.21000
Polish Zloty	PLN	0.22173
Singapore Dollar	SGD	0.74627