currency conversion

[#1]

hi,

how can i convert or toggle betwwen any currency to USD and AED.for eg i have 10rs so i want a list box having USD and AED and when i click to USD this 10rs should convert into USD and when i click AED this 10rs should convert into AED.

[#2]

Hi Darshika,

My suggestion is to import a table with the currency.

For example:

CURRENCY:

LOAD

Currency, Exchange

FROM xxx.xls.

Then you add this as a selection box but with one figure always selected. And based on this you multiply your figure by the exchange, like so. Sales * Exchange.

Regards,
Marius

[#3]

Hi marius,

thanks but i already have those column having the values(in USD and AED)now i want two buttons one say USD and another one as AED and now if i click to USD the other graphs on my sheet should change accordingly as i toggle

[#4]

Hi,

Can you share the sample file.

[PradeepReddy]

Try some thing like this.

Create a variable 'vCurrency' and assign the currently selected value(Currency Value) to it.

In all expressions use the variable 'vCurrency'

Ex: Sum(Sales)/vCurrency

If you want to use the buttons instead of List box,

Create 2 buttons(USD, ADE) and assign the currency values to the variables from Properties--> Action.

In all expressions use the variable 'vCurrency'.

Regards,

Pradeep

[#6 · Accepted solution]

thanks pradeep taniparthy,i tried its working perfectly

[#7]

Hi,

Please find the attachement. Hope this will be helpfull

[PradeepReddy]

Close the thread by marking Correct answer, so that it will be helpful for others.