# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for
Did you mean:
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
Partner

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

Champion
Contributor II
Author

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

Specialist II

Hi,

you must tell :

if not, it's done for each row

regards

Partner

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

Try

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

Tags
Community Browser