The Formula Builder Interface

The Formula Builder interface consists of three main sections, as indicated in the screen capture below:

•

Formula—The editor in which you write the formula.

•

Standardized Syntax also provides a Testing tab, which enables you to define the input data to test your formula. For more information, see Using Standardized Syntax Mode.

•

Data Engine Syntax provides a Test link that tests the formula using random values from the dataset.

•

Insert Functions—Lists all the functions available to use in your formula, provides a helpful description of each function, and enables you to add functions to the formula.

•

Insert Columns—Lists all the dataset columns available to add to your formula.

Basic components of formulas