Weighted average

3 posts 0 new
Log in or register to post comments.

Weighted average

How can I use a Weighted average in Metrics?

Thanks

The weighted average is mentioned in Formula Examples: http://kb.qpr.com/qpr2015-1/index.html?formula_examples.htm
 

"To calculate weighted averages: In the Value settings, define a specific series for each measure that contains the weighting coefficients. Define the identifier of the series to be e.g. WW. Now in a parent element you can calculate the weighted average of all the subelements with the formula:

SUM(?.ACT()*?.WW())/SUM(?.WW())"