Hi Everyone,
I am currently working on a currency conversion dashboard.
I have two tables.
First table consist of the various amount and the currency they are invested in.
For eg
Amount Base Currency
10000 SGD
20100 TWD
19000 HKD
2nd table is a currency table and they are all pegged to CHF ( I m required to pull from a particular website )
( meaning to say 1 SGD = 0.76885 CHF, 1 TWD = 0.0344568 CHF etc )
Date SGD TWD HKD
30/6/2012 0.76885 0.0344568 0.13962
My aim is to allow users to view the amounts in the currency that they choose. Eg when a user selects 'TWD' in a field called 'Chosen Currency', All the amount will be displayed in TWD.
My expression is below
Sum( (Amount * ( Concat([Base Currency]))/Concat([Chosen Currency]) ) but it is not working
I have also tried using $(= Concat([Base Currency]) in place of Concat([Base Currency]) but it doesnt work. The text does not appear.
I would like to ask if it's possible to multiply a fix column A by a variable column B whose name is based on the value in another field.
Any opinon is appreciated!
Regards,
Roger