6 Replies Latest reply: Jan 20, 2014 3:20 PM by Paul Yeo RSS

    How to make my % row display 51% instead of 77% ?

      Hi All

       

      I have a straight table . the first row summary % display wrong value. How to make it display 51 % ? if i set the total mode = Average , it display 77% also wrong.

       

      Expression :-

      =if(fabs(column(1))=0,1,column(2) / fabs(column(1))-1)