sum issue

[Mahamed_Qlik]

Hi

I have field EC_CONT which has some amount as value. but when I take sum of it the value is getting changed .

for example - for COMM_NO 1021792, there are multiple amount so if I take sum ( EC_CONT) in third column the sum is showing wrong. However if i take sum ( 80.682) it should display 80.682 and simillar...

[vincent_ardiet_]

Could be that your datamodel needs to be reviewed.
Else, do you have a key field to identify the unicity of EC_CONT?
You can do a SUM(Distinct EC_CONT) but this is dangerous if you have real duplicates.