Rollup/consolidation does not include negative number

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

View Rollup.doc

(52.5 KiB) Downloaded 306 times

[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,

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

[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!