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!

Incorrect Grand Total

JorgeRSAug 18 2010 — edited Aug 24 2010
Hi people,

I'm doing a simple report with 3 measure columns (A, B and C). Where C is a calculated column (A/B).

Aggregated Rule for A and B is "SUM".

Result set example:

| Dimension_Column | A | B | C |
| Value1 | 2 | 1 | 2.000|
| Value2 | 1 | 1 | 1.000 |
| Value3 | 1 | 1 | 1.000 |
| Value4 | 2 | 1 | 2.000 |
| Value5 | 1 | 1 | 1.000 |
| Value6 | 1 | 1 | 1.000 |
| Value7 | 1 | 1 | 1.000 |
| Value8 | 2 | 1 | 2.000 |
| Grand Total | 11| 8| 1.000|

The problem is that the grand total in column C is wrong, what I want is the result of the division between 11 / 8 = 1.375

I have tried different aggregation rules in anwers, I have created a new measure in RPD and also I have added the following statement <ReportAggregateEnabled>true</ReportAggregateEnabled> in the instance.xml file with no success. :-(

Any one has a clue how to fix this?

Thanks & regards,
Jorge.

Edited by: JorgeRS on Aug 23, 2010 11:23 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details