Show TOC

Procedure documentationCreating a Formula Expression Locate 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 Note

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

    End of the note.

  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 (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 (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 (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.

    This graphic is explained in the accompanying text.

    Example 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.

    End of the example.

  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.

      This graphic is explained in the accompanying text.

    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   Insert Expression   Create  .

        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   Insert Expression   Select  .

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

      • To create a data object.

        1. Choose   Insert Data Object   Create  .

        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   Insert Data Object   Select  .

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

      This graphic is explained in the accompanying text.

    Note Note

    You can also create complex formulas using nested operands.

    End of the note.

  10. Choose the Activate button.

  11. Save the expression.