Question4Replies2953Views GorlaRohitK Member since 2015 3 posts Accenture Services Pvt Ltd Posted: 4 years agoLast activity: 4 years 3 months ago 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 agoBASAVARAJ 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 agonistr PEGA replied to GorlaRohitKThis has already been discussed herehttps://mesh.pega.com/message/198239#198239https://mesh.pega.com/message/237265#237265 Posted: 4 years agoThommeeS Master Data replied to GorlaRohitKHello!You got to do what you wanted? Accepted Solution Posted: 4 years agoWill 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.