Aggregate Inside an IIF Statement in SSRS

Question

I would like to get the sum of a column for every currency type display that in a tablix row. I tried the below code but is not working. I hope that someone can show me the correct code.
The total of the LAK currency also is not correct.
Thanks for anyone who can show me how to do this.

Jes Sie · Answer

I found the answer I was looking for...   =SUM(VAL(IIF(Fields!CurrencyType.Value =  "USD" , Fields!ActualAmountPaid.Value,0)))

Jes Sie · Answer

I tried the below code but gives me an error =SUM(IIF(Fields!CurrencyType.Value =  "USD" , Fields!ActualAmountPaid.Value,0))