Currency Problem

[AH]

Hi All,

I need to create a text box which calculates the Gross Revenue (Sum of Line Amount) for Transactional, Functional and Reporting Currencies.

but in one text box i would be able to switch between Currencies(Transactional, Functional and Reporting).

I have different Currencies(Transnational[ALL Currency], Functional[USD, GBP] and Reporting currency[USD].

Is there anyway you can help me with that? I would really appreciate your help.

Thanks,

AhmedTest - Copy.qvw

[Anonymous · Accepted solution]

Does the attached give you food for thought ?

[AH]

Hi Bill,

Thanks for your reply. It looks great. I actually attached a sample copy of the data but need to apply that to the actual Dashboard and test the data if your provided attached file logic give me exactly what i need.

Again Thanks for your reply. I really appreciate it!

Thanks,

Ahmed