Question

4
Replies
3055
Views
GorlaRohitK Member since 2015 3 posts
Accenture Services Pvt Ltd
Posted: May 17, 2016
Last activity: August 26, 2020
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
Share this page LinkedIn