Question7Replies990Views Jay_KS Member since 2008 8 posts Luxoft DXC Posted: October 9, 2015Last activity: May 27, 2016 Closed Percentage in Report SummaryHow do I let Pega automatically calculate % in Summary view.I have a requirement where below are summary columnsColumn 1 - Total Case CountColumn 2 - Cases completed within TargetColumn 3 - % of cases completed within Target - ideally - Column 2/ Column 1 % but I am not finding a way to calculated this automaticallyThanksK S Jayakumar Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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. Posted: 5 years agonistr PEGA replied to Jay_KSDo 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. Posted: 5 years agoJay_KS Luxoft DXC replied to nistrWe 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) Posted: 4 years agoThommeeS Master Data replied to Jay_KSSoundarajan Jayakumar, hello!Did you use the standard or custom control? Could you tell us a bit more about this?Thanks! Posted: 4 years agoMahesh Midthuru PEGA replied to Jay_KSHi 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)*100If 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 Posted: 4 years agoMahesh Midthuru PEGA replied to Mahesh MidthuruFYI, my implementation is tried in Pega v7.1.9. Posted: 4 years agoThommeeS Master Data replied to Mahesh MidthuruUmamaheswar MidthuruHello!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 Posted: 4 years agoMahesh Midthuru PEGA replied to ThommeeSFYI, 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.