Exercise 102: Define a Formula for the Exceed Customer Expectations Element.
|1. Open the Using Formulas Exercise Model.|
|2. Open the Scorecard Navigator.|
|3. Double-click the Exceed Customer Expectations element:|
|4. The Element Properties window will open. Select the Series tab.|
|5. On the Series tab, select the Actual (ACT) series and change the Input Type to Formula:|
|6. The Formula window will open. Select Custom and define the formula as AVERAGE(RANGE(?.ACT())). Now the average of the Range values is calculated from all sub-elements:|
|7. Click OK.|
|8. A dialog will open asking if the values for all periods should be recalculated. Click Yes.|
See the Formulas section in QPR Metrics - User's Guide for more information about using formulas.