TM1 Forum

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

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'];

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

Cheers,
Martin

hi
Thanks you very much

Boris