Incomprehensible result

[Anonymous]

Hi

I need help to understand very incomprehensible result in chart (the document attached)

I have 2 tables, linked by the column FAMILLE_NUM

The column "AFFECTE" is equal to 0/1

When I select some families (for example ), the result of the expression sum(AFFECTE) is 2, whereastheres is just one family xho is selected

Please, Help

That is te first time I see something like tthis

Laurent

[Gysbert_Wassenaar]

Your data contains duplicate records. QV doesn't show duplicates, so you can only see it because the count and sum of AFFECTE are 2 instead of 1.

[Anonymous]

Hi

Thank for your response

What expression can I use in order to have the good result ?

[Gysbert_Wassenaar · Accepted solution]

You can add the distinct keyword to the expressions: sum(distinct AFFECTE).