Calculating Currency in the Sum column

[#1]

Hej together,

i have a column with currency and a cloumn amount in one table

Amount	Currecncy
1212	EUR
2145	USD

The second Table is the USD and the eychange rate.

Currency	Change Rate
USD	0,8

Well, i want the Amount 2145 with the currency USD that calculate the amount with the change rate (0,8) an refresh the amount 2145 with the new amount of the change rate.

Could you help me.

Thank you.

[jvitantonio]

A:

LOAD * INLINE [

    Amount, Currency

    1212, EUR

    2145, USD

];

B:

left join LOAD * INLINE [

    Currency, Rate

    USD, 0.8

];

Final:

LOAD 

if(isnull(Rate),Amount,Amount*Rate) as Amount, Currency

Resident A;

Drop table A;

[#3]

IT doesn't works.

The formula shows me only the EUROs and note calculatete Dollar in Euros.

Do you have an new tipp for me.

Thanks.