how calculate price weighted average in tm1

[borisslu]

hi,
can u help me?

for example:

product Quantity Price

X+Y 10 6 how can i calculate this price

X 5 10

Y 5 2


sometimes i have more then 2 products
Thanks

[Wim Gielis]

Hello Borisslu

You could create a measure called Revenue, begin:

['Revenue']=N:['Quantity']*['Price'];

Most of the time, Price will be manual input (or TI process, or Excel sheet) at the leaf level. At the consolidated level, you have the weighted average for Price as:

['Price']=N:STET;C:['Revenue']\['Quantity'];

[Martin Ryan]

There are a few methods for calculating averages in this post: http://forums.olapforums.com/viewtopic.php?f=21&t=388

Cheers,
Martin

[borisslu]

hi
Thanks you very much

Boris