299x
003112
2024-01-31

Formulas

The "Edit Formula" dialog box manages the equations of parameterized input.

Entering Formulas

To define a formula for a table cell or dialog field, use one of the following options:

  • Use the Edit Formula button in the table toolbar.
  • Click on the yellow corner in the cell or dialog box (available if formula is provided).
  • Use the Arrow Right button in the dialog text box.

The "Edit Formula" dialog box appears.

Defining Formula

Enter the "Formula" into the text box. It can include numerical values, parameters, or functions. If the formula is defined correctly, the "Result" of the equation appears in the field below.

Use the Global Parameters button to open the Global Parameters list. Then, select the parameter or define a new variable. Use the "OK & Insert" button to import the parameter into the formula.

You can also describe formulas by functions that follow the conventions of JavaScript and the usual references. This way, you can also define conditions and conditionals for the value of the equation; for example, as follows:

  • A > B ? 1 : 2
  • if (A < B) 1; else 2

Furthermore, it is possible to address objects by means of their numbers and certain properties in the formula. This way, you can use, for example, the lines[3].length entry to refer to the length of Line 3. You can access the complete list of object references, including syntax, with the Info button.

Info

With a prefixed equal sign, you can enter a formula directly into the cell; for example, =2.5*PI.

Displaying Formulas

A formula can be used in the cell of a table as well as in the input field of the corresponding dialog box. Since tables and dialog boxes are interactive, you can access the formulas in both input modes.

If a yellow triangle is displayed in the upper left corner of a cell, a formula is assigned to it. A red triangle means that the formula is incorrectly defined.

Use the Show Formula button to control whether the formula or the corresponding value is displayed in the cell (see the image Button "Edit Formula").

To delete a formula, select the corresponding cell. Then, click the Delete Formula button.

Parent Chapter