Creating a Formula Using Data Engine Syntax Mode

You create formulas in Data Engine Syntax mode using the Formula Builder. Any formulas that you create can be used in nested formulas (see Adding a Nested Formula).

For general information on using the Formula Builder interface, see The Formula Builder Interface.

To create a formula using Data Engine Syntax (Legacy) mode

1.

Open the Formula Builder interface and select Data Engine Syntax (legacy).

2.

Enter a name in the Formula Name box.

3.

To add a function to the formula, type it directly in the editor. A suggestion box is displayed with columns and functions that fit your text. You may also use the following method:

a.

Under Insert Functions, select the function that you want to insert. The description box displays helpful information about the function.

Tip:To only display functions for a specific category, select a category from the dropdown box above Insert Function.

b.

Click Add to Formula. The formula displays in the Formula box.

4.

To add a column to the formula, type it directly in the editor. A suggestion box is displayed with columns and functions that fit your text. You may also use the following method:

a.

Insert the cursor in the desired location in the formula.

b.

Under Insert Columns, click on the column that you want to insert. The column displays in the Formula box.

5.

Continue to add functions and columns until your formula is complete.

6.

Before you can use the formula, you must test it. At any time while building your formula, click Test. The formula will be tested with random values from the dataset. An error displays if the formula has a mistake.

7.

Click Save to save the formula.