SUM() Function: How to avoid duplicate numbers?

[#1]

Greetings everyone!

Another noob doubt...

I'm using a SUM() function to bring total values grouped by a code, and even using the DISTINCT clause, it brings me a lot of duplicate values, each one of these related to different records... Here is a sample of the report itself...

...And the code I wrote for it:

Where am I going wrong?

Thx in advance!

[hector]

Hi,

maybe there are more decimals, because if this value 11,06 is the same for the 3 Shippers, Qlikview will show it as 11,06 in only one row, and if you check the frecuency, it will show you 3

try changing the number of decimals and see what happens

Rgds

[#3]

Hello again Héctor!

You are absolutely right... I raised the decimal precision to 8, and it worked.

My datasources are very messed up... there's no control upon its input.

Thanx for the flash-answer!