Creating a Formula Expression

Show TOC

Procedure

Open the application in the Object Manager panel.
Under the Detail section, choose the Contained Objects tab.
The Contained Objects tab page appears.
Choose Expression from the Type field and choose Create Object.
In the Object Creation dialog box that appears, choose Formula from the Type field.
Enter the following data:
- Name
- (Optional) Short Text
- (Optional) Text
Choose Create & Navigate to Object.

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

End of the note.
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
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.
End of the example.
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.
    
    Choose Insert Expression Create .
    In the Object Creation dialog box that appears, create the expression.
    For more information, see Creating Expressions
  - To select an existing expression.
    
    Choose Insert Expression Select .
    In the Object Query dialog box that appears, select the expression.
  - To create a data object.
    
    Choose Insert Data Object Create .
    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.
    
    Choose Insert Data Object Select .
    In the Context Query dialog box that appears, select the data object.
Note
You can also create complex formulas using nested operands.

End of the note.
Choose the Activate button.
Save the expression.