Creating Calculated Key Figures

[former_member240517]

Hello!

 

This blog post is going to show you a bit more about calculated key figures. I have written about data operators that can be used while creating those key figures and they can be found on the blog posts below:

• Mathematical Operators: https://blogs.sap.com/2019/04/17/creating-key-figures-mathematical-operators/


• Data Operators: https://blogs.sap.com/2019/04/24/creating-key-figures-data-operators/


• Trigonometric Operators: https://blogs.sap.com/2019/04/24/creating-key-figures-trigonometric-operators/


• Boolean Operatos: https://blogs.sap.com/2019/04/12/creating-key-figures-boolean-operators/

For restricted key figures, please refer to Creating Restricted Key Figures

Creating Calculated Key Figures

In order to create calculate key figures, please follow with the steps below:

1. Go to Business Analytics work center and Design Key Figures view;


2. Click on New button;


3. Type a name;


4. Select a data source;


5. Type: Calculated Key Figure;


6. Click on Next button;


7. In the 2nd step of your key figure creation, you will have on the left side of your screen a list with the available key figures that can be used for building a new one. Double click on the needed existent key figure and you will see that it has been added into the formula label, located in the center of the screen;


8. Use the aforementioned blog posts in order to choose the proper operators to build a formula/function in the formula label;


9. Repeat the steps 8 and 9 until your formula label is complete with the information you need;


10. Click on Next button;


11. In the 3rd step (key figure properties), you will have few options that are listed after this steps;


12. Define the needed properties to achieve your business goals;


13. Click on Next button;


14. Review your key figure;


15. Click on Finish button.

Key Figure Properties

• Local Calculation


• Exception Aggregation 


• Conversion

Common Calculated Key Figures Questions/Issues

• 2768977 - Calculated key figure formula does not work.


• 2579377 - Cannot use Characteristic to Create Calculated Key Figure


• 1862299 - Create new calculated Key Figure using Boolean conditions


• 1967299 - How to Show a Calculated Key Figure in Percent


• 1859568 - Error While Adding Key Figure to the Report


• 2799937 - Result Row in Report Shows Wrong Total When Condition / Value Filter is Active


• 2579697 - How to Remove the Unit of Measure/Currency Sign from Key Figure


• 1960149 - How to Replicate the Same Key Figure Results from a Key Figure Created as Copy


• 1963229 - Currency not Converting when using a Custom Key Figure in the report.


• 2051415 - How to Create Key Figures That Show Positive Values Only


• 1790974 - Percentage Value is Displayed as * in the Report


• 1708645 - Analytics Content Cannot Be Created or Rebuilt


• 2497672 - Key Figure Formula is too large


• 2672356 - Currency cannot be removed for Standard Key Figures in Reports

I hope this blog post will be able to help you in any doubt you might have about calculated key figures. If you need any further assistance, please do not hesitate on bringing it in the comments area below! Your use case could be another's doubt as well. 🙂

 

Sincerely,

Elise.