How to view data in multiple Currency options

[#1]

Can anyone help???

I am building an app and one of the requirements is to allow the user to be able to select different currencies. I know that a variable needs to be created but not sure how to go about it.

I have created the inline load below which is a Data Island in my data model:

Currency:

LOAD * INLINE

[

     CURRENCY, ExchangeRate

     AUD, 1.0908

     CAD, 1.0187

     EUR, 0.7399

     GBP, 0.6650

     USD, 1.000

]

I want the user to be able to select one of the five currency's from a list box and all related numbers should change to the selected currency.

Sample app attached.

Thanks!

[christophebrault]

Hi,

In you listbox, force to one selected value.

Then add *ExchangeRate to all you expressions, and it's done !

[daveamz · Accepted solution]

Hi,

     Like Chris said, you'll have to use * ExchangeRate in your expressions sum(Sales*ExchangeRate)

BR,

David

[#4]

Alot simpler than I thought!

Thanks for your help guys!

[#5]

So, how did your Dev Cert App turn out?

[a272070]

Hi,

In your sample application, what is the original currency? Would you just not include whatever it is in the list box "currency"? Is there a way to label it originally what it is or not?

Thanks!