Testing a Formula in Standardized Syntax

To test your formula in standardized syntax

1.

In Standardized Syntax mode, create your formula and click Testing. If the formula contains any syntax errors or incorrect usage of data types, the Testing tab is not available.

Note:The Input box lists all the columns in the formula in JSON format, and it assigns values from the dataset to those columns.

2.

In the Input box, review the values provided and modify as needed. To obtain a new set of values from the dataset, click Randomize Data.

Tip:You can evaluate more than one set of values at a time by editing the JSON and adding another set in the columns.

3.

Click Test Formula. The output is displayed in the Output box. If an error occurs during formula evaluation, click See Console Output to display a detailed error response from the database engine.

4.

Click Save. The formula is ready for use.