Having problems in summing two kinds of data (euro and usd) even after conversion

[trishita]

I have written a code for Total commit in euro as such: 
if (Match([Summary_List.currency],'EUR'), sum([Total Commit]),
if (Match([Summary_List.currency],'USD'), sum(([Total Commit]/ 1.1452 )),
if (Match([Summary_List.currency],'SEK'), sum(([Total Commit]/ 10.32 )),
'Unknown')))

But my problem is when I have two kinds (both in euro and usd)of Total commit I am getting no value.For eg Yielco has values for Both Euro and USD but with my logic it is now showing nothing for total commit in euro.I want to see the sum of both the quantities here

[Mauritz_SA]

Hi Tri**bleep**a

Is your Summary_List.Currency a dimension or a measure in your table? Make sure it is a Dimension.

Regards,

Mauritz