I have a requirement to display percentages in a report based on some data available in my index table. For every case I have max three entries in my index table for category ABC, PQR and XYZ. And for each category I have success count and failure count.
My requirement is to display the Overall percentage of success and failure.
Below is how I would like to display my data in a report:
For each category (as shown in below report), I’m able to display success and failure counts, Number of Attempts = (Success + Failure) Counts as expected in my main report using the sum function. I’m able to calculate the success and failure percentage shown in the below main report by using a sub report which would return the total of success, failure count per category, using which I’m calculating SubReport.SuccessCount/( SubReport.SuccessCount+ SubReport.FailureCount) in main report.
I have used aggregate function Average, since I would need the percentage at the top level too. However, the value is not correct, the top the percentage displayed be a percentage of all the categories together. But with function like Average the individual categories are working fine but the top level row is taking average of the individual percentage of categories i.e, 54% success = (67+50+44)/3,
Expected result should be : (10/19)*100 = 53%(Approx).