Show TOC

Procedure documentationCreating a Formula Expression Locate this document in the navigation structure

Procedure

  1. In the Object Manager panel, under the Detail section, choose the Assigned Objects tab.

    The Assigned Objects tab page appears.

  2. Choose Expression from the Type field and choose Create Object.

  3. In the Object Creation dialog box that appears, enter the following data:

    • Name

    • Short Text

    • Text

  4. Choose Formula from the Type field and choose Create & Navigate to Object.

    Note Note

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

    End of the note.

  5. Add the result data object. You can create a new data object or add an existing data object.

    • Select an Existing Data Object

      1. Choose Graphical Access (Graphical Access).

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

      3. In the Object Query dialog box that appears, select the data object and choose Select.

    • Create a New Data Object

      1. Choose Graphical Access (Graphical Access).

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

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

        More information: Creating Data Objects

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

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

        Choose   Insert Expression   Create  .

        More information: Creating Expressions

      • To select an existing expression.

        1. Choose   Insert Expression   Select  .

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

      • To create a data object.

        Choose   Insert Data Object   Create  .

        More information: Creating Data Objects

      • To select an existing data object.

        1. Choose   Insert Data Object   Select  .

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

      This graphic is explained in the accompanying text.

    Note Note

    You can create complex formulas using nested operands.

    End of the note.