Currency Conversion

[#1]

Hi All,

I have the dashboard with amount showing in GBP. I want to convert into USD, INR or any other currencies based on the conversion rate.

I will be getting the conversion rate from the database on a day to day basis.

Please  help me with this how to change the currency.

I have attached the QVW. Please have look into it.

Thanks in Regards,

Keerthi

[#2]

Hi Arun,

One more question. This takes the max of a date and displays.

When user selects Year or Month or Quarter, I want the average(Conversion) factor for the particular YEAR , MONTH or QUARTER to be displayed.

When year is selected it should be independent of Max Date

Please help me with this.

Thanks and Regards,

Keerthi

[#3]

Hi Arun,

Here is my expression

if(GetSelectedCount(OpenClaim_Year),avg({<OpenClaim_Year=$>}Conversion)*sum([Amount Approved]),Sum({<DateConversion={"$(=Date(Max(Date#(DateConversion,'DD-MM-YYYY')), 'DD-M-YYYY'))"}>}[Amount Approved]*Conversion))

Similarly i can do it for MONTH and QUARTER.

Is there any other way of doing other than this ??

Thanks and Regards,

Keerthi

[#4]

Hi,

Yes, you can use this approach,

or you can use two expression (One for avg and second for max), and conditionally enable them based on selection(Year, month , Quarter) as per requirement.

Also, if you are using average, you should remove date from dimension as it will give wrong idea to user, you can use conditional ennoblement there also...