Weighted average

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

Weighted average

How can I use a Weighted average in Metrics?


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: