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
Instead of using total have you tried to use data items itself for example
[SBU]
[SBE][SBU]