Crosstab Rounding Issue

[ChTripathi]

We have a cross tab report with summaries at all levels.

The requirment is to have the data values in the report to be rounded and as whole numbers.

However we cannot round the measure value at the row/data item level since the aggregate summary value comes out higher

Ex:


Heirarchy SBG > SBU > SBE

lets say values in db are as follows



SBG SBU SBE Fact
X    Y   Z   1.5
X    Y   Z   2
X    Y   A   3.5
X    Y   A   4.5


Therefore expected output is as follows

X>Y>Z = 4
x>Y>A = 8
Summay level X>Y = 12
Grand Total = 12


If we round at data item level the values would be as follows
This needs to avoided

X>Y>Z = 4
X>Y>A = 9
Summary level X>Y = 13
Grand Total X = 13

On setting the data format in the report as 0 we are getting inconsistent rounding as follows


x>Y>Z = 3 (instead of expected 4)
X>Y>A = 8
Grandtotal = 11

[pricter]

Instead of using total have you tried to use data items itself for example

   
       [SBU]
   [SBE][SBU]