How to Calculate Absolute Sum

 

 

 

([Total sum],[sum1])

 

 

 

 The first argument is a SUM and second is a filter

With the help of it, we select all positive values.

The second part of the formula will be 

 

 

ABS(([Total sum],[sum1]))

 

 

The first argument is the SUM of the values, the second filter of all negative values

And all this calculation wraps with the function ABS (you can read more here).

The whole formula will have a look:

 

 

([Total sum],[sum])+ABS(([Total sum],[sum1]))

 

 

And the final result of it will be 5

 

Check out this related content:

Academy course

Sisense Documentation