Learn more

Formula Table window

This window lets you set up a formula table by entering the conditional criteria, expected responses, and values you want returned to the formula. The first thing you do is choose a condition from the Variable / Formula list. Then the Formula Table window opens so you can enter the name, specify the number of conditions, and complete the formula table.

You can set up a formula table with one or two conditions:

One dimensional - sets up a formula table with a single input condition. During takeoff, the formula table returns a value based on the entry for that variable or formula. Example
Two dimensional - sets up a formula table with two input conditions. During takeoff, the formula table returns a value based on the entries for two variables or formulas. Example

To open: From the Databasetab, click Formulas (Formulas group)then click Formula Tables. (In classic view, select Database menu > Formulas > Formulas).

Tip: To resize the Formula Table window, drag one side of the frame.