Calculation Type: Relative

“Relative” means that the next value which is equal to the value defined with selection condition is chosen.

The function runs through the complete input data and applies each calculation rule where the selected conditions are met.

Procedure

Function Access

Follow the steps below to access the Calculation function of type “Relative”:

  1. In the client where SAP Profitability and Performance Management is installed, choose Start of the navigation pathSAP Menu Next navigation step Profitability and Performance Management Next navigation step Modeling Next navigation step Start My EnvironmentsEnd of the navigation path.

  2. The Environment screen appears in a separate browser window. Choose an existing environment and continue. Within the environment, you can set up the newly added function.

Function Configuration

Follow the steps below to configure the Calculation function of type “Relative”:

  1. In edit mode, configure the following required fields in the header. For more information about the header, see the Key Features section in Calculation.

    • Calculation Type = “Relative”
    • Result Handling
    • Include original Input Data
    • Result Model Table
    • Suppress initial Result

  2. Define the input function to be used on the Input tab.

  3. Define the function to be used on the Lookup tab, if needed.

  4. Define the fields to be used on the Signature tab.

  5. On the Rules tab, each calculation rule defines semantically an if-then statement. The “if”-part specifies the relevant records of the rule's input data. The “then”-part is an action, and contains a list of fields and formulas that have to be calculated.

    Proceed as follows to configure the rules:

    1. On the Rule tab of your Calculation function, choose (Add).

    2. The Add Details screen is displayed. Enter the following information:
      • Rule
      • Description

    3. Choose OK.

    4. Select the created rule.

    5. In the Selection section of the created rule, choose (Add).

    6. On the Fields screen that is displayed next, choose the field to be used and then choose OK.

    7. Select the field and choose Selection Condition.

    8. On the Selection Condition screen, define the selection condition to be used and choose OK.

    9. In the Action section of the created rule, choose (Add).

    10. On the Fields screen that is displayed next, choose the field to be used and choose OK.

    11. Select the field and choose Formula.

    12. On the Formula screen that is displayed next, define the formula to be used and choose OK.

  6. Define the checks to be used on the Checks tab, if needed.

  7. Choose Save and then choose Activate.

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 add and remove functions in SAP Profitability and Performance Management environments, see Function Hierarchy.