Display percentages in header in a summary report
Hi
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).
Hi
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).
Below is my sample data:
|
Failure count |
Success Count |
Category |
CaseID |
||||
|
0 |
1 |
PQR |
ABC-MYAPP-WORK A-1 |
||||
|
0 |
1 |
ABC |
ABC-MYAPP-WORK A-1 |
||||
|
0 |
1 |
XYZ |
ABC-MYAPP-WORK A-1 |
||||
|
0 |
1 |
ABC |
ABC-MYAPP-WORK A-2 |
||||
|
0 |
1 |
PQR |
ABC-MYAPP-WORK A-2 |
||||
|
3 |
0 |
PQR |
ABC-MYAPP-WORK A-3 |
||||
|
1 |
0 |
PQR |
ABC-MYAPP-WORK A-4 |
||||
|
1 |
0 |
ABC |
ABC-MYAPP-WORK A-4 |
||||
|
1 |
0 |
XYZ |
ABC-MYAPP-WORK A-4 |
||||
|
1 |
1 |
PQR |
ABC-MYAPP-WORK A-5 |
||||
|
1 |
1 |
XYZ |
ABC-MYAPP-WORK A-5 |
||||
|
1 |
1 |
ABC |
ABC-MYAPP-WORK A-5 |
||||
|
0 |
1 |
PQR |
ABC-MYAPP-WORK A-6 |
||||
|
0 |
1 |
ABC |
ABC-MYAPP-WORK A-6 |
Pegasystems Inc.
IN
This is because the calculated average in percents was rounded-off to the nearest value.
As per your logic, SubReport.SuccessCount/( SubReport.SuccessCount+ SubReport.FailureCount)*100 should give the actual value NOT the rounded value.
ABC = 4/6*100 = 66.66%
XYZ = 2/4*100 = 50%
PQR = 4/9*100 = 44.44%
If you average now it becoems (66.66 + 50 + 44.44)/100 = 53.70% (This is what your expectation is).
See if this helps.