# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

## 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 ?

5 Replies
Highlighted
Partner

## 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.

Esteemed Contributor

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

New Contributor II

## 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 .??

Valued Contributor II

## 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

Partner

## 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))