QPR Knowledge Base 2017.1

Using Formulas

Using Formulas

Previous topic Next topic No directory for this topic  

Using Formulas

Previous topic Next topic Topic directory requires JavaScript Mail us feedback on this topic!  

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.