How can i reflect the changes of currency in my straight table

[ferha_jafri]

Hi,

I need help ,what i am trying to do is i have a straight table in which i had calculations for Budget and actual budget.

I want to create a muli box for INR,and Dollar as we know that Dollar value is more than Rupee so waht i want that when

i select INR the result budget comes in INR and when i select Dollar the value of budget get multiplied by Rs.56.

The currency table i have created through Inline so what changes i have to make in the table or how can i alter the calculation

of budget when i select diff currency.

[amars]

Hi,

You can have one Table in your DataModel which will hold ConversionRatio for different currencies you use.

The Format for the Table can be (FromCurrency, ToCurrency, ConversionRatio).

Now link the FromCurrency with the Currency in ur Data using same alias. Now show ToCurrency on the Dashboard, select one of the ToCurrency and set Always one selected property checked. So this way user can see all the Amount in one Single ToCurrency at any point of time.

For the Chart use (Amount * ConversionRatio).

Hope this helps.

Thanks

Amar

[ferha_jafri]

Sorry Amar i am not able to understand here the connection b/w From Currency and To Currency and in my Currency field i have 100 currency so what will be ToCurrency field will have and what will be my ConversionRatio field will have