TM1 Forum

Hi,
I am having an issue with Performance Modeler setting Weighted Average to a Consolidated level on a dimension (pic attached). we are using TM1 10.2.2.

When I tried to set "weighted average" at consolidated level, it errors "Items Not recognised". This is a built-in function and I have no choice on setting items for the calculation. other calculations where I used existing items (Margin %= Margin /Sales) have no issue. Has anyone run into this? Please share correcting the error or how it has to be used?

Thanks,
Luther.

Might be a silly question but have you dragged elements into the formula?

Hi,

You have to drag values for (Total product of value and weight) and Weight
Create one more element or variable
V1= Value * Weight
Weighted Average = V1/Weight

It will work!!!!

Thanks Nidhi. I will check.