Feedback on: QPR Knowledge Base 2017.1 - Use Range Values in FormulasUse_Range_Values_in_FormulasMetrics Training Guide > Formulas in Depth > Use Range Values in Formulas /Dear Support Staff,
Use Range Values in Formulas
It would not be wise to calculate the average of two elements, when the units and scales are different. For instance, how can the QPR Metrics take the average of sub-elements if Gross Margin % uses the unit "Percentage" while the Operating Profit uses the unit "1000 Dollars"? The answer to this is that the scorecard formula should take the average of the elements' range values.
Exercise 129: Use a Range Function in the Employee & Innovation Perspective Formula.
1. Open the Dentorex Group Scorecard model.
2. On the Model Navigator frame, select the Dentorex Group scorecard.
3. On the Scorecard Navigator frame, double-click the Employee & Innovation perspective.
4. The Element Properties window opens. Switch to the Series tab and highlight the Actual series:
5. Click the Define button next to the Input Type drop-down menu to open the Formula window:
6. Select Customize and define the formula as AVERAGE(RANGE(?.ACT())). Now the average of the Range values is calculated from all sub-elements:
7. Click OK and answer Yes to the recalculation question.
See the Using Range Values topic in QPR Metrics - User's Guide for more information.