Load data applying the exchange rate

[#1]

Hi everibody,

I am searching for a way for loading a field "revenues" applying to its values the exhange rate, in dependence of another field, "currency"

I am pretty new to Qlikview and I have no idea on how to do it. Maybe it needs a complitely different approach...

Someone can help?

Thanks!

[#2]

Just to be clear:

I am loading values both in DOLLARS and EUROS, and I want them in DOLLARS