1. User's Guide
  2. Working with Management Ledger Profitability
  3. Working with Management Ledger Allocations
  4. Creating and Managing Management Ledger Allocations
  5. Defining and Managing Calculation Rules in Management Ledger Models
  6. Creating Management Ledger Custom Calculation Rules
  7. Defining Formulas for Management Ledger Custom Calculation Rules

Defining Formulas for Management Ledger Custom Calculation Rules

Defining a Target for Management Ledger Custom Calculation Rules describes how to enter a range of dimensions and members that are affected by a Management Ledger custom calculation rule. The next step is to define the calculation formula for the rule.

To define the formula for a Management Ledger custom calculation rule:

  1. In an open custom calculation rule, click the Formula tab (Figure 10-18).

    Figure 10-18 The Formula Tab of the Management Ledger Custom Calculation Rule Definition Area


    Enter required information as described in the following steps.
  2. Enter the formula as a text string (see Management Ledger Custom Calculation Rule Formula Syntax for format information).
  3. Select Validate Formula to determine if the formula is valid.
  4. When the formula is complete, click Save button (Save).

Note:

Following rule calculation, you can define appropriate model views and use the Rule Balancing or Manage Queries task areas to view custom calculation rule results.

To view context definitions for the custom calculation rule, see Viewing Contexts for Management Ledger Custom Calculation Rules..

To edit and delete rules, see Managing Management Ledger Rules.