Issue with Performance Modeler setting Weighted Average to a Consolidated level

[LutherPaul]

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.

[Walker86]

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

[Nidhi]

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

[LutherPaul]

Thanks Nidhi. I will check.