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