QPR Knowledge Base 2017.1

Using Wildcards in an Accumulation Formula

Using Wildcards in an Accumulation Formula

Previous topic Next topic No directory for this topic  

Using Wildcards in an Accumulation Formula

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

Wildcards can be used in expressions (formulas) with scorecard, measure and series identifiers. There are two types of wildcards in QPR Metrics: one for representing any string of characters of any length and one for representing any single character.

 

The two wildcard types cannot be mixed, because they both use the same wildcard character - question mark ("?").

 

mouse_24 Exercise 127: Define an Accumulation Formula for the Product Image Strategic Objective in the USA Sales Office Scorecard.

 

BTN_AR131. Open the Dentorex Group Scorecard model.
BTN_AR132. On the Model Navigator frame, click the btn_expand_hierarchy buttons to expand the scorecard hierarchy and select the USA Sales Office scorecard:

pic_scorecard_hierarchy_usa_sales

BTN_AR133. On the Scorecard Navigator frame, click the btn_expand_hierarchy button next to the Customer perspective to expand the element hierarchy and double-click the Product Image strategic objective:

pic_element_hierarchy_usa_prodimage

BTN_AR134. The Element Properties window opens. Switch to the Series tab and highlight the Actual series:

pic_series_actual_highlight2

BTN_AR135. On the Input Type field, select Formula and click Define.
BTN_AR136. The Formula window opens. Select Customized and delete the formula that is in the window:

pic_formula_customized

BTN_AR137. Enter AVERAGE(?.ACT()) as the formula:

pic_formula_average

BTN_AR138. Click OK and answer Yes to the recalculation question.

The "?" wildcard means, in this case, that all actual values of the sub-elements are calculated with the average function.

For more information, see the Wildcards topic in QPR Metrics - User's Guide.