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.