Question

1
Replies
222
Views
Pooja Maadishetty (PoojaM44)
Bank of America

Bank of America
US
PoojaM44 Member since 2017 1 post
Bank of America
Posted: March 20, 2019
Last activity: March 22, 2019
Posted: 20 Mar 2019 22:52 EDT
Last activity: 22 Mar 2019 0:36 EDT
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).

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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.