11 Replies Latest reply: Apr 27, 2012 3:07 PM by Hamish Donald RSS

hierarchy question, using expression to sum up all the level - rollup

Amien Amien

i have a material hierarchy which is all loaded into one table. Its from bottom to top.

Pathname is like this .../...../.....

 

All normal..

 

But now i want to load another table which links to the hierarchy table. This new table contains to columns. MaterialID (for linking to the hierarchy table) and a column which contains # of days to produce.

 

now i pu this in my expression : SUM(Days)

 

this all works fine, but when i 'roll-up' the total days are not calculated. When i roll-up to the highest level. I will see the number of days of the highest level. It doesn't to a sum of all the days that are also on a lower level.

 

how can i fixed this