Executing the Calculate Form and Calculate Currencies Business Rules

Data source types: Oracle Planning and Budgeting Cloud

The Calculate Form business rule is created for each form to calculate subtotals. The Calculate Currencies business rule is created for forms that include multiple currencies in a row, column, or page to enable the conversion of values among available currencies.

The order in which business rules are launched is important and may affect the data. If you plan to launch both Calculate Form and the Calculate Currencies business rules, always run the conversions before subtotaling the form.

To launch the Calculate Form and Calculate Currencies business rules in Excel:

  1. Open a form.

    Any data that is not saved on the spreadsheet is lost when you launch the business rule.

  2. From the Planning ribbon, select Calculate, and then Rules on Form.

    The business rules associated with the form are displayed in the Business Rules dialog box.

  3. Complete one or both of the following actions:

    • To convert currencies, select Calculate Currencies

    • To calculate subtotals, select Calculate Form

  4. Click Launch.

    If the calculation is successful, the values in the database reflect the results of the calculation.

Related Topics:

Launching Business Rules in Excel

Entering Runtime Prompts