This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
on - edited on by
jcordell
How to Calculate Absolute Sum
We have a table with data and we are going to calculate the absolute SUM for [sum] column.
We divide this into two parts. First of all, we SUM all positive values with the formula
([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
