Question

6
Replies
1340
Views
Close popover
Srividhya Renganathan (Srividhya.R)
Common Wealth Bank of Australia
Senior Case Engineer
Common Wealth Bank of Australia
AU
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,
Close popover 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.