Formula Editor Dialog Box

You use the Formula Editor dialog box to create formulas quickly. In the dialog box, you can enter the formula directly or compose it by selecting the appropriate parts of the formula.

You open the dialog box by clicking the Edit button in a formula box or column. Multiple forms contain these boxes or columns, such as Import Scenarios (SM206025), Export Scenarios (SM207025), and Payment Methods (CA204000).

Tip: The name of the dialog box is the same as the name of the box or column from which you open it.

Formula Editor Dialog Box

The Formula Editor dialog box, which is shown in the screenshot below, includes the following panes:

  • Component Type pane (see Item 1): Displays the types of operators, functions, and fields that can be used as formula components. You can search for the needed type by using the Search box at the top of the pane.

    Click any of the types to display the corresponding list of available components in the Component Selection pane.

  • Component Selection pane (Item 2): For the component type chosen in the Component Types pane, displays the list of available components.

    Click a component to add it to the formula at the bottom of the dialog box. You can search for the needed component by using the Search box at the top of the pane.

  • Formula Text pane (Item 3): Contains the text of the formula, which you can edit manually.

    The formula may include the selected components, arguments of manually inserted components, and other elements, all arranged in accordance with the syntax of the formula.

Figure 1. Formula Editor dialog box


Table 1. Buttons The dialog box has the following buttons.
Button Description
Validate Checks whether the formula typed in the Formula Text pane is valid.
OK Inserts the formula you have created into the formula box or column and closes the dialog box.
Cancel Closes the dialog box without saving your changes.