Calculation
Calculation is a data enrichment function that can be used to enhance the data in a dataset with calculated attributes based on predefined rules at runtime.
The enriched data can then be used for consumption in downstream processes such as allocation. If the data to be calculated is already available in the source data, the calculated data is only overwritten if the condition values are met. Otherwise, the source values are retained.
Key Features
Header
The Calculation function includes a parser to detect dependencies between fields used in formulas and to ensure that rules are executed in the correct order internally. Circular dependencies are not allowed.
In the header, you define the principal behavior of the calculation.
You can use the calculation type as a specific header option:
The system applies the calculation formula to the grouping result.
Rules
Each calculation rule semantically defines an if-then statement. The “if” part specifies for which records of the input data the rule is relevant. The “then” part is an action and contains a list of fields and formulas that have to be calculated.
Related Information
For more information about common aspects of SAP Profitability and Performance Management functions, see Concepts for Key Users.
For more information on how to set up the Calculation function of type “Workbook Adapter”, see Administration Guide for SAP Profitability and Performance Management > Installation Information > Implementation Sequence > Calculation Workbook Adapter Setup.