1 Reply Latest reply on Nov 1, 2018 5:34 AM by ShivaRam Chennapragada

    Calculate percent of sum of a row with grand total

    Shantam M

      I am trying to calculate percent of success as following -

       

      Total records where StatusMsg is Authorization Success (16821) divided by Grand Total (23050) . So success rate becomes 16821/23050 = 0.729

       

       

      How do I add another row with Success Rate in percent.

      Ideally I would want another row to be added as "Success Rate" and under the "0" column, I'll see the percentage.

      If there are any other workarounds, I'm open to that as well.

       

      Thank you