Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can add the distinct keyword to the expressions: sum(distinct AFFECTE).
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.
Hi
Thank for your response
What expression can I use in order to have the good result ?
You can add the distinct keyword to the expressions: sum(distinct AFFECTE).