Use the QPR Metrics User's Guide to Fetch a Function to the Model
Feedback on: QPR Knowledge Base 2017.1 - Use the QPR Metrics User's Guide to Fetch a Function to the ModelUse_the_QPR_ScoreCard_Users_GuMetrics Training Guide > Formulas in Depth > Use the QPR Metrics User's Guide to Fetch a Function to the Model /Dear Support Staff,
Use the QPR Metrics User's Guide to Fetch a Function to the Model
Exercise 128: Use the QPR Metrics User's Guide to Fetch a Function to the Operating Profit Formula
1. Open the Dentorex Group Scorecard model.
2. On the Model Navigator frame, select the Dentorex Group scorecard.
3. On the Scorecard Navigator frame, click the button next to the Financial perspective to expand the element hierarchy and again click the button next to the Profitability.
4. Double-click the Operating Profit measure:
5. The Element Properties window opens. Switch to the Series tab.
6. Click the Define button to open the Formula window.
7. Select Customized and delete the formula in the window:
8. Click the Function button and select SUM from the drop-down menu:
9. Click the Help button or press the F1 key to open the QPR Metrics - User's Guide.
10. In the user's guide, switch to the Search tab, type "built-in functions" to the search field and press Enter:
11. In the search results section, double-click the Built-in Functions:
12. For faster access in the future, switch to the Favorites tab and click Add. This way, the topic is added to your favorites, and you can access it directly from the Favorites tab.
13. Scroll down the right frame, select CUMULATIVE and highlight the formula as in the picture below:
14. Press Ctrl + C to copy the formula.
15. Go back to the Formula dialog in the client and click inside the brackets of the SUM() function.
16. Press Ctrl + V to paste the formula:
17. Replace expression_list from the formula with "?.ACT(-3)", where the question mark defines that all sub-elements are calculated, and ACT(-3) defines the series.
18. Replace relative level with 2, to describe that the cumulative values are reset after 3 values.
19. Replace formula with "sum", to describe that the cumulative values are calculated with the SUM function.
20. The formula should now be SUM(CUMULATIVE(?.ACT(-3),2,sum)).
21. Click OK and answer Yes to the recalculation question.
See the Built-in Functionstopic in QPR Metrics - User's Guide for more information.