Question

6
Replies
1295
Views
Srividhya.R Member since 2015 28 posts
Common Wealth Bank of Australia
Posted: June 19, 2018
Last activity: June 27, 2018
Closed

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