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