Formula List window

This window provides a list of formulas or variables from which you can select a condition for a formula table or an item table. It opens in the following situations:

  • When you create a formula table or an item table.
  • When you add a second condition to a formula table or item table.

The list displays formulas from which you can select when you are building your table.

If a formula that you want to use in your table does not exist, you can add it "on the fly," as follows:

  1. Click [Create Formula].

    You can also right-click anywhere in the list, and then select Create Formula from the shortcut menu.

  2. In the Adding Database Formula window, enter properties for the new formula.

  3. Click [OK].

After you select a formula, you return to the parent window where you edit the formula table or item table.

Tips:  

  • To locate a particular formula, type the name or part of the name of the formula in the box, and then click [Search]. The resulting list is filtered to include only formula names that include the characters you typed.
  • Double-click a formula to select it for the condition.