Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use
=fabs()
Hey Alejandro,
I tried that but its not working! Do you have any other sugession?
Regards,
Vikas
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.