QPR Installation Instructions

Using Formulas

Using Formulas

Previous topic Next topic  

Using Formulas

Previous topic Next topic JavaScript is required for the print function  

mouse_24 Exercise 102: Define a Formula for the Exceed Customer Expectations Element.

 

BTN_AR131. Open the Using Formulas Exercise Model.
BTN_AR132. Open the Scorecard Navigator.
BTN_AR133. Double-click the Exceed Customer Expectations element:

pic_scorecard_hierarchy5

BTN_AR134. The Element Properties window will open. Select the Series tab.
BTN_AR135. On the Series tab, select the Actual (ACT) series and change the Input Type to Formula:

pic_element_properties_series

 

BTN_AR136. 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:

pic_formula

BTN_AR137. Click OK.
BTN_AR138. 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.