This content has been marked as final.
Show 4 replies

Re: how to show the sum(amount) with positive and negative value in absolute term ?
Siddharth Sheshadri Jun 8, 2018 3:30 AM (in response to Nupur Gupta)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 ?
Nupur Gupta Jun 8, 2018 3:57 AM (in response to Siddharth Sheshadri )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 ?
Olivier GAUTIER Jun 8, 2018 4:03 AM (in response to Nupur Gupta)Hi,
you must tell :
fabs(sum(total <your break> amount)
if not, it's done for each row
regards

Re: how to show the sum(amount) with positive and negative value in absolute term ?
Devyanshu Gupta Jun 8, 2018 6:10 AM (in response to Nupur Gupta)If fabs is giving the wrong result try using "SIGN" function
Try
=Sum(Amount)*Sign(Sum(Amount))

