values not displaying correctily

[jagan.dish]

Hi Guru,
           Could pleas help me out it's an urgent , the issue is i got different wrong data in 2012 totals values as compared to the original values for example:total should be like 60,187.62 and i got some thing like 60,165.62 and all the individual values also vary...i tried checking the Aggregate& Rollup Aggregate n times but i did't get the correct values .....It would be helpful....


Thanks in advance

[MFGF]

Do you have any active filters - either in your report or in the model? A single transaction with a value of 22 or multiple smaller transactions totalling 22 appear to be missing. Because the decimal portion is the same, I'm pretty confifrnt it's not a rounding or aggregation issue. The other possibility is that an inner join is causing one or more rows to be omitted.

MF.