Question4Replies3146Views×Close popoverGorla Rohit Kumar (GorlaRohitK) Accenture Services Pvt Ltd Accenture Services Pvt Ltd IN View ProfileSend Message GorlaRohitK Member since 2015 3 posts Accenture Services Pvt Ltd Posted: May 17, 2016Last activity: August 26, 2020Posted: 17 May 2016 5:35 EDTLast activity: 26 Aug 2020 8:17 EDT Closed Solved How to calculate percentage (for a column) in Report Definition.As of now, there is no specific aggregate function available like count for percentage in report defintion. Is there any control exist in report definition to calculate the percentage ?We are using an aggregate functions for SUM and COUNT available in OOTB. Now to calculate the percentage we need to use/pass the aggregated values and not direct property values.We want to get the Result = Count (.pyid) * 100 /Count(.other property).But we can pass only direct property values to function and not the aggregated values i.e. pyID can be passed as any input but not COUNT(.pyID).Any suggested way to solve this.Thanks 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: 4 years agoPosted: 17 May 2016 5:41 EDT×Close popoverBasavaraj Kadakol (BASAVARAJ) PEGA Technical Manager Pegasystems Inc. IN View ProfileSend MessageBASAVARAJ PEGA replied to GorlaRohitKIf you can create sub-reports which can calculate the aggregate values, then main report can calculate the percentage by using the pxDivide and pxMultiply SQL functions, this way it can be achieved. Posted: 4 years agoPosted: 17 May 2016 7:13 EDT×Close popoverRajiv Nistala (nistr) PEGA Senior Manager - Engineering Pegasystems IN View ProfileSend Messagenistr PEGA replied to GorlaRohitKThis has already been discussed herehttps://mesh.pega.com/message/198239#198239https://mesh.pega.com/message/237265#237265 Posted: 4 years agoPosted: 27 May 2016 9:37 EDT×Close popoverGeorgy Kuskov (ThommeeS) Master Data Consultant Master Data RU View ProfileSend MessageThommeeS Master Data replied to GorlaRohitKHello!You got to do what you wanted? Accepted Solution Posted: 4 years agoPosted: 27 May 2016 9:55 EDT×Close popoverWill Cho (Will Cho) PEGA Principal System Architect Pegasystems US View ProfileSend MessageWill Cho PEGA replied to ThommeeSYes, looks like our developers found a solution to our client use case.We built a custom FA and used AVERAGE in RD to show a % value.