Show TOC

Creating a Formula ExpressionLocate this document in the navigation structure

Procedure

  1. Open the application in the Object Manager panel.
  2. Under the Detail section, choose the Contained Objects tab.

    The Contained Objects tab page appears.

  3. Choose Expression from the Type field and choose Create Object .
  4. In the Object Creation dialog box that appears, choose Formula from the Type field.
  5. Enter the following data:

    • Name

    • (Optional) Short Text

    • (Optional) Text

  6. Choose Create & Navigate to Object .
    Note

    If you choose Create button, the created formula object appears under the Contained Objects tab.

  7. Add the result data object. You can select a standard type, create a new data object or add an existing data object.

    • Select a Standard Type

      1. Choose Graphical Access.

      2. In the context menu, choose Default Objects and choose the data object type.

    • Select an Existing Data Object

      1. Choose Graphical Access.

      2. In the context menu, choose Select... .

      3. In the Context Query dialog box that appears, select the data object.

    • Create a New Data Object

      1. Choose Graphical Access.

      2. In the context menu, choose Create... .

      3. In the Object Creation dialog box that appears, create the data object.

        For more information, see Creating Data Objects

  8. Create the formula using expressions, data objects, mathematical and logical operators.
    Example

    If you want to create a formula, 3*1, then in the formula builder,

    1. Choose Number .

    2. In the Insert dialog box that appears, enter 3 and choose OK .

      The number 3 appears in the Formula field.

    3. Choose * .

    4. Choose Number .

      In the Insert dialog box that appears, enter 1 and choose OK .

  9. You can also create the formula in the expert mode.

    1. Choose Switch to Expert Mode .

      A text box appears next to the Formula field.

    2. You can insert expressions, data objects, string, number, amount, quantity and comment in the formula.

      In the context menu of the text box:

      • To create an expression.

        1. Choose Start of the navigation path Insert Expression Next navigation step Create End of the navigation path.

        2. In the Object Creation dialog box that appears, create the expression.

          For more information, see Creating Expressions

      • To select an existing expression.

        1. Choose Start of the navigation path Insert Expression Next navigation step Select End of the navigation path.

        2. In the Object Query dialog box that appears, select the expression.

      • To create a data object.

        1. Choose Start of the navigation path Insert Data Object Next navigation step Create End of the navigation path.

        2. In the Object Creation dialog box that appears, create the data object.

          For more information, see Creating Data Objects

      • To select an existing data object.

        1. Choose Start of the navigation path Insert Data Object Next navigation step Select End of the navigation path.

        2. In the Context Query dialog box that appears, select the data object.

    Note

    You can also create complex formulas using nested operands.

  10. Choose the Activate button.
  11. Save the expression.