topic Wrong sum but good values in QlikView https://community.qlik.com/t5/QlikView/Wrong-sum-but-good-values/m-p/1280403#M621192 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I'm new from a Qlikview.</P><P></P><P>I have an issue when i use the sum function</P><P></P><P>sum(distinct {$}(field1-field2)*field3)</P><P></P><P>The number which is returned is totally wrong whereas my values are true</P><P></P><P>I made some tests and i think the parenthses make it wrong.</P><P></P><P>Thank you for your help.</P><P></P><P>Sandy.</P></BODY></HTML> Thu, 02 Feb 2017 11:01:50 GMT 2017-02-02T11:01:50Z Wrong sum but good values https://community.qlik.com/t5/QlikView/Wrong-sum-but-good-values/m-p/1280403#M621192 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I'm new from a Qlikview.</P><P></P><P>I have an issue when i use the sum function</P><P></P><P>sum(distinct {$}(field1-field2)*field3)</P><P></P><P>The number which is returned is totally wrong whereas my values are true</P><P></P><P>I made some tests and i think the parenthses make it wrong.</P><P></P><P>Thank you for your help.</P><P></P><P>Sandy.</P></BODY></HTML> Thu, 02 Feb 2017 11:01:50 GMT https://community.qlik.com/t5/QlikView/Wrong-sum-but-good-values/m-p/1280403#M621192 2017-02-02T11:01:50Z Re: Wrong sum but good values https://community.qlik.com/t5/QlikView/Wrong-sum-but-good-values/m-p/1280404#M621193 <HTML><HEAD></HEAD><BODY><P>Not sure what you mean here?</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>The number which is returned is totally wrong whereas my values are true</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Can you share a sample? One thing I would recommend it to cautiously use DISTINCT with Sum. It may not do what you think it might be doing. But without knowing much, I am not sure what your issue might be</P></BODY></HTML> Thu, 02 Feb 2017 15:45:21 GMT https://community.qlik.com/t5/QlikView/Wrong-sum-but-good-values/m-p/1280404#M621193 sunny_talwar 2017-02-02T15:45:21Z