key figure total different after drill down

Question: Hi,

I haven't been able to resolve an issue in which a key fig has one total with no drill down, but when I do drill down by order for example and sum up the amounts, they are way different. Per this forum, I checked key fig and ckf properties for calculate result as... summation. There are other kf's in the same query that are the same w/ or w/o drill down. I don't see any difference between the properties of the kf's that are ok and the ones that aren't. Pls advise.

Thanks,
John

Answer:
It sounds like an aggregate corruption.
Try to run the query in RSRT, without aggregates, and check if totals are equal. If yes, you've to detect which aggreggate is wrong, and to rebuild it.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.


Tuly Idiot's fan club active member.

Answer:
Is there maybe a condition applied on this specific key figure ?

Answer:
Thanks all for your help.
Copyright ?2007 - 2008 www.jt77.com