1 Reply Latest reply: Feb 2, 2017 10:45 AM by Sunny Talwar RSS

    Wrong sum but good values

    Sandy Kilos

      Hello,

       

      I'm new from a Qlikview.

       

      I have an issue when i use the sum function

       

      sum(distinct {$}(field1-field2)*field3)

       

      The number which is returned is totally wrong whereas my values are true

       

      I made some tests and i think the parenthses make it wrong.

       

      Thank you for your help.

       

      Sandy.

        • Re: Wrong sum but good values
          Sunny Talwar

          Not sure what you mean here?

          The number which is returned is totally wrong whereas my values are true

          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