This content has been marked as final.
Show 2 replies

Re: how to make absolute sum?
Nick Gan Nov 14, 2012 11:22 AM (in response to Nick Gan)Well, i got the solution.
The calcutlation was doing the sum of the gap in each row.
So, if we are doing it like this fabs( sum (a  b) ) , the total value will still take the minus sign into the calculation.
But, this sum( fabs( a  b ) ) , will fix the problem.

Re: how to make absolute sum?
whiteline _ Nov 14, 2012 1:11 PM (in response to Nick Gan)Hi.
This will work only if you have one a and b value for each of your dimension values.
More common solution is:
=sum(aggr(fabs(sum(a)sum(b)), Dimesnion)))