Page 1 of 1
Rollup/consolidation does not include negative number
Posted: Thu Apr 09, 2009 3:25 pm
by ltnite
I need help figuring out why a rollup does not add negative numbers. When I drill down to zero level, I find the elements and their values. Is this a feeder issue? Attached is screenshot of cube view.
Re: Rollup/consolidation does not include negative number
Posted: Thu Apr 09, 2009 4:15 pm
by Steve Rowe
Hi Itnite,
Hmm, not sure you even have a problem? I just typed some of the numbers from the cube into excel and added them up and the totals seem to match up with the ones the view is showing.
Can you be more specific about what is not working?
Cheers,
Re: Rollup/consolidation does not include negative number
Posted: Fri Apr 10, 2009 1:57 pm
by ltnite
Steve, thanks for the quick response. You are correct. I compared the cube view with a previous Excel slice and realized the slice was missing element 9531. I should've done that first before driving myself batty tracing calculations and checking feeders. Thank you so much for your help.
Re: Rollup/consolidation does not include negative number
Posted: Sat Apr 11, 2009 6:40 am
by Steve Rowe
lol, happens to everyone, the number of times I've had the whole "TM1's deliberatly playing tricks on me, it can't possibly be me making a mistake" conversation!