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
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.