Question

4
Replies
3285
Views
Gorla Rohit Kumar (GorlaRohitK)
Accenture Services Pvt Ltd

Accenture Services Pvt Ltd
IN
GorlaRohitK Member since 2015 3 posts
Accenture Services Pvt Ltd
Posted: May 17, 2016
Last activity: August 26, 2020
Posted: 17 May 2016 5:35 EDT
Last activity: 26 Aug 2020 8:17 EDT
Closed
Solved

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

Reporting
Moderation Team has archived post, 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.