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
Try this,
Create a calc field 'Success Rate' using this logic,
SUM(IF [statusMsg] = 'Authorization Success' THEN [0] END)/TOTAL((SUM([0]))
Hope this helps.
Best,
Shiva.