Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Percentage calculation at Grand Total Level

827643Feb 24 2011
Hello,

I have issue in calculating the percentage at grand total level. I have three measures (A count, B count and Total count). These measures are defined in rpd with aggregation rule as sum. In answers i am calculating A % as 100*A count/Total Count. I have defined the aggregation rule for this percentage column as default. I am able to get correct % results for sub total level but getting wrong percentage values when Grand Total level is added. Going through some posts in this forum, people have suggested to enable this tag in instance config file.

<ReportAggregateEnabled>true</ReportAggregateEnabled>

After adding this tag, i am able to get correct results. The issue is when there is no data i am able to see table view with all columns having blank values even though i have defined the no result view.

Please Help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details