Incorrect Grand Total
JorgeRSAug 18 2010 — edited Aug 24 2010Hi 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