3 Replies Latest reply: Oct 23, 2013 11:08 PM by jagan mohan rao appala RSS

    Sum Positive and Negative Numbers qlikview Regardless of Sign


      Hi All,

       

      Is it possible to get sum of negative and positive Numbers Regardsless of sign.I am using this expression (DOCNUM)-count(DMSDOCNUM) but it is not solving my problem. i Should be getting around 35000 records but beacuse of negative and positie sign i am only getting 2700 records.

       

      Can anyone please help me with this.  Attaching my case scneraio here.

       

      Regards,

      vikas