Sum not getting calculated properly

[Deepak13]

Hello All

Please refer the screenshot below. the sum should be 4+3+2+1=10 but when I write an expression in table it is coming out as 5006.

[Or]

These two tables are not mutually exclusive. The left side shows a list of distinct combinations, while the right side shows a sum of the values. There could be any number of rows for each combination of values (which you can see if you add Count(tradecount) to your left-side table).