TM1 Forum

In TM1 when we build a hierarchy we can do automatic aggregations (SUM and SUBTRACT - if we define negative weights) based on the hierarchy rollups.

I want to get the Average of the children values in the consolidation levels. Can we do AVERAGE within the hierarchy rollups as well?

If yes then how?

Hi,

In common situations you will need to use rules to calculate averages. See the FAQ post and look for "Calculating Averages for Consolidations" - this will give you a.o. a link to this post.

Michel