Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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.