Sum Positive and Negative Numbers qlikview Regardless of Sign

[#1]

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

[Alejandro_Hernández]

use

=fabs()

[#3]

Hey Alejandro,

I tried that but its not working! Do you have any other sugession?

Regards,

Vikas

[jagan]

Hi Vikas,

Try like this

=Fabs(DOCNUM)+ count(DMSDOCNUM)

If it is not working then check with if like this

if(Number < 0, Number * -1, Number)

Hope this helps you.

Regards,

Jagan.