Question
Accenture Services Pvt Ltd
IN
Last activity: 26 Aug 2020 8:17 EDT
How to calculate percentage (for a column) in Report Definition.
As of now, there is no specific aggregate function available like count for percentage in report defintion. Is there any control exist in report definition to calculate the percentage ?
We are using an aggregate functions for SUM and COUNT available in OOTB. Now to calculate the percentage we need to use/pass the aggregated values and not direct property values.
We want to get the Result = Count (.pyid) * 100 /Count(.other property).
But we can pass only direct property values to function and not the aggregated values i.e. pyID can be passed as any input but not COUNT(.pyID).
Any suggested way to solve this.
Thanks
Accepted Solution
Pegasystems Inc.
US
Yes, looks like our developers found a solution to our client use case.
We built a custom FA and used AVERAGE in RD to show a % value.
Pegasystems Inc.
AU
If you can create sub-reports which can calculate the aggregate values, then main report can calculate the percentage by using the pxDivide and pxMultiply SQL functions, this way it can be achieved.
Pegasystems
IN
This has already been discussed here
Accepted Solution
Pegasystems Inc.
US
Yes, looks like our developers found a solution to our client use case.
We built a custom FA and used AVERAGE in RD to show a % value.