Question13Replies3338Views DamienRichard Member since 2013 11 posts Capgemini Posted: 4 years agoLast activity: 4 years 1 month ago Closed Solved Report Definition - Calculate percentagesHello,After a look on the PDN and Mesh I need some help for using RD.I need to calculate a percentage between one group of instances and another one.I tried to use sub-reports but I encountered an error when I use Divide FA.I created to reports one that count all instances and another one that count instances with criterias.I don't find how to do the operation between them.Any help will be welcome.Thanks,Damien***Updated by Moderator: Marissa. Removed user added #helpme group tag. Apologies for confusion, shouldn't have been an end-user option*** Low-Code App Development 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 agoPrudhvi_N PEGA replied to DamienRichardHi Damien, Please find my answers inline. I need to calculate a percentage between one group of instances and another one. Ans- Can you please create a function alias of class "Embed-User-Function" use it for calculating percentages. I tried to use sub-reports but I encountered an error when I use Divide FA. Ans- When did you faced the error? If it is a compilation error in section means there is a HotFix for it. Please let me know which version of pega you are using. For more help, please share some attachment with screenshots such that I will replicate and let you know the response. Thanks and Regards, Prudhvi Ranjan Posted: 4 years agoDamienRichard Capgemini replied to Prudhvi_NHi Prudhvi, I attached some screenshots of my configuration. Concerning your first answer I will try but I don't think this can be apply in my case (Except if I hardcode some field but I need RD reusable). Concerning your second answer, I am facing the error when I run the RD. You will find information in attachments. Thanks and regards, Damien Posted: 4 years agonistr PEGA replied to DamienRichardPlease provide the details of the error faced with pxDivide function along with the log files. Also screenshots showing how the sub report and the main report have been configured with this function would help identify the issue quickly. Posted: 4 years agoDamienRichard Capgemini replied to nistrHi, The only detail of the error is in the screenshot attached. I attached the log file but the error is not explicit. I already attached reports configurations but I add the sub reports configuration in the main report. Both sub reports have the same configuration. Posted: 4 years agonistr PEGA replied to DamienRichardPlease provide the version of the Pega 7 platform being used Posted: 4 years agoDamienRichard Capgemini replied to nistrIt is a Cloud environment. Version 7.1.10 Posted: 4 years agonistr PEGA replied to DamienRichardPlease raise a SR for this. Posted: 4 years agoVidyaranjan MOD replied to nistrHi DamienRichard , Once you go ahead and raise an SR as suggested by Rajiv, I request you to share the SR number here, so that we can track it for you within the thread. Vidyaranjan A V | Community Moderator | PegaProductSupport | Pegasystems Inc. Posted: 4 years agoDamienRichard Capgemini replied to VidyaranjanHi, So I created an SR. SR-A95156 Posted: 4 years agoVidyaranjan MOD replied to DamienRichardHi Damien, Thank you for notifying us and tagging it under related support case number for tracking. Vidyaranjan A V | Community Moderator | PegaProductSupport | Pegasystems Inc. Posted: 4 years agoNareshKandru Virtusa replied to DamienRichardAny update on this SR? We have the same requirement to provide the feasible solution. Awaiting inputs.. Posted: 4 years agoLochan_DV MOD replied to NareshKandruHi Naresh, I just had a look and this SR is still under inverstigation. We will update the resolution here, once it reaches a conclusion. Regards, Lochan | Community Moderator | Pegasystems Inc. Accepted Solution Posted: 4 years agoLochan_DV MOD replied to NareshKandruHi Naresh, The SR was closed with the below suggested local-change. However, please note that this was not verified by Damien. Root Cause - The Subreport configured with 'Do not match rows' doesn't work in main report's RAF. Suggested local-change: 1. Use single subreport with 2 joins and add count function on joined columns2. Use this subreport in main report Regards, Lochan | Community Moderator | Pegasystems Inc.