4 Replies Latest reply: Jun 8, 2018 6:10 AM by Devyanshu Gupta

# how to show the sum(amount) with positive and negative value in absolute term ?

Hi ,

how to show the sum(amount) with positive and negative value in absolute term ? while changing by using fab or any other set analysis the sum(amount) is giving me wrong values ..... how can we achieve this in qlik sense ?

• ###### Re: how to show the sum(amount) with positive and negative value in absolute term ?

Give an example. I don't get your need exactly.

• ###### Re: how to show the sum(amount) with positive and negative value in absolute term ?

now suppose i have amount as -100, 100 , 20,-80  if I give sum of these amount it will be -60 and in my chart it will show as -60 ....but I want to show the abs value in my chart as 60

I used fabs(sum(amount)) it is giving me value as 300 (which is not correct)

is there any other expression or formula to get absolute 60 .??

• ###### Re: how to show the sum(amount) with positive and negative value in absolute term ?

Hi,

you must tell :

if not, it's done for each row

regards

• ###### Re: how to show the sum(amount) with positive and negative value in absolute term ?

If fabs is giving the wrong result try using "SIGN" function

Try

=Sum(Amount)*Sign(Sum(Amount))