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,

I want only one currency and the latest date.

By default without selection it should display the amount in GBP based on the latest date.

When i select any currency it should get multiplied with the conversion for the latest dates

[tresB]

May be like this?

PFA

[#4]

Hi,

Please find the attached solution.

Let me know if not correct.

[#5]

Thanks a lot Arun. This is what i wanted.

Could you please explain this

Thanks & Regards,

keerthi

[#6]

Thanks a lot Tresesco Thanks for your valuable time

[#7]

Hi,

In dimension i have used this as calculated dimension.

Aggr(MaxString(DateConversion),Currency1)

For every currency, it will give you maximum date value.

In you data example , datas are in form of string as it was inline data.

In real dates, you should use max() instead of maxstring().

Like this:

Aggr(Max(DateConversion),Currency1)

[#8]

Hey Arun Goel,  Could you please explain how it works. I didnt understand why the FIrstSortedValue() is used in the expression.

[#9]

hi,

FirstSortedValue(Conversion,-Date#(DateConversion,'DD-MM-YYYY'))

It will sort the Conversion value according to DateConversion and will return first value.

By default, it returns value with lowest weight,

But id we get get value with max sort weight by reversing the sign.

[#10]

By the way, the Arun Goel you mensioned, was not real me...;)..this is my account...

[#11]

Thanks Arun.