Percentage in Report Summary
How do I let Pega automatically calculate % in Summary view.
I have a requirement where below are summary columns
Column 1 - Total Case Count
Column 2 - Cases completed within Target
Column 3 - % of cases completed within Target - ideally - Column 2/ Column 1 % but I am not finding a way to calculated this automatically
Thanks
K S Jayakumar
Pegasystems
IN
Do you really need to do this in a Summary View?
This can easily be done by using a declare expression. Alternatively, you can have a HTML control which does the calculation on the UI.
If it is with a report definition, you can write a custom SQL function to do this.
Pegasystems Inc.
IN
We tried to use HTML Control, but we are not able to calculate properly.
We used control, but we are not able to show it at the top (e.g. below near 6, 7, 9 and All as a summary column)
Master Data
RU
Soundarajan Jayakumar, hello!
Did you use the standard or custom control? Could you tell us a bit more about this?
Thanks!
Pegasystems Inc.
US
Hi Jayakumar,
As per your requirement I understood that you have two fields i.e. TotalCases and CasesCompletedIntimeCount.
Now you want to calculate the percentage of the total cases completed within time i.e. Percentage = (CasesCompletedIntimeCount/TotalCases)*100
If this is your requirement then I had create a data type with the two fields of type integer which holds CasesCompletedIntimeCount and TotalCases as shown below,
In report definition I added the third column with the following functions as shown below,
Hi Jayakumar,
As per your requirement I understood that you have two fields i.e. TotalCases and CasesCompletedIntimeCount.
Now you want to calculate the percentage of the total cases completed within time i.e. Percentage = (CasesCompletedIntimeCount/TotalCases)*100
If this is your requirement then I had create a data type with the two fields of type integer which holds CasesCompletedIntimeCount and TotalCases as shown below,
In report definition I added the third column with the following functions as shown below,
Now I added the sample data for the two fields in the data type and the third column value is calculated from the report definition change as shown below,
Finally my report definition output is calculating the percentage correctly as shown below,
Note: I had exported the report to Excel and I can see the calculation done properly.
Kindly let me know if this is your requirement.
Regards,
Mahesh
Master Data
RU
Hello!
We have count cases based on pyID, and it is necessary to calculate the percentage of the count cases created by the administrator from the total count cases.
Your decision not to take into account Summary Report Definition.
Thanks
Pegasystems Inc.
US
FYI, I think the below article also discussed about the similar issue, hope the below article might help you.
Re: How to calculate percentage (for a column) in Report Definition.