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:


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:


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


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:


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


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.