Srividhya.R Member since 2015 28 posts
Common Wealth Bank of Australia
Posted: 2 years ago
Last activity: 2 years 2 months ago

Pega 7.2.2 - Report definition - Summary Report - Calculations

We have a report in work class which calculates the total cost of column A of all the work items and the total cost of another column B.

Now we need to find the ratio of sum(column A )/ sum(column B), in the same report.

Can we acheive this using Custom SQL function? Have any of you done this before?

Please note : I can't create a subreport to do this, as it is already having a subreport. A validation error of "Subreport cannot contain itself in a subreport" is thrown.

Thanks for your help

Low-Code App Development Reporting
Moderation Team has archived post
Share this page LinkedIn