13 Replies Latest reply on Jul 17, 2017 5:12 AM by Suvas Chandra

    Percentage Calculation

    Suvas Chandra

      I have Grand Total of all the rows like this:

       

      Now, I have to calculate the percentage and need to place below the Grand Total in a separate row. But the calculation is different. It will be based on the right most column.

       

      Example:  105471 /106333 *100 % = 99.189 %,

      24/106333 *100 = 0.022% and so on and the last one (below 106333) should be 100%

       

      How can I do this ?