2 Replies Latest reply: Nov 14, 2012 1:11 PM by whiteline _ RSS

    how to make absolute sum?

    Nick Gan

      Hi,

       

      I'm doing fabs(sum(a) - sum(b)) , in a pivot table.

      by row, the calculation is good. all figures are in positive.

       

      but, the partial total in pivot is not good, it still do the sum according to the original negative values...

       

      any helps please...