Question

1
Replies
158
Views
PoojaM44 Member since 2017 1 post
Bank of America
Posted: 1 year ago
Last activity: 1 year 7 months ago
Closed

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).

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

Low-Code App Development Reporting
Moderation Team has archived post
Share this page LinkedIn