Common Wealth Bank of Australia
Last activity: 27 Jun 2018 2:20 EDT
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