Creating a Formula Using Standardized 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 Standardized Syntax

Open the Formula Builder interface and select Standardized Syntax.

Enter a name in the Formula Name box.

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:

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.

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

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:

Insert the cursor in the desired location in the formula.

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

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

Tip:Standardized Syntax Mode provides automatic error detection features. The editor continuously evaluates formulas as you type, and it immediately notifies you of syntax errors as well as incorrect usage of data types. Hover over a highlighted error to display additional details.

Before you can use the formula, you should test it with sample data. If your formula uses correct syntax, you may display the Testing tab to test your formula. For more information, see the following section, “Testing a Formula in Standardized Syntax.”

Click Save to save the formula. In Standardized Syntax Mode, the Save button is displayed on the Formula tab.