Standardized Syntax Reference

This section describes formula syntax when using Standardized Syntax mode.

Field/Column Syntax

Insert columns by using the Insert Columns dropdown, by entering the column name, or by selecting them from the Column/Function suggestion box. Columns are displayed as pills inside the formula.

Function Syntax

Function names must be in uppercase and must be followed by a bracketed argument list. For example:

ABS(25)

Comments Syntax

You can add single-line comments to the formula that should start with //. For example:

// This is a comment

Operator Syntax

The following table shows the available operators. Note that normal operator precedence applies.

Available Operators

Symbol	Operation	Description
*	Multiplication	Multiplication of two numbers.
/	Division	Division of two numbers.
+	Addition	Addition of two numbers.
-	Subtraction	Subtraction of two numbers, or negation of a number.
=	Equality	Test equality of two values.
>	Greater Than	Test if the first value is greater than the second value.
<	Less Than	Test if the first value is less than the second value.
>=	Greater Than or Equal	Test if the first value is greater than or equal to the second value.
<=	Less Than or Equal	Test if the first value is less than or equal to the second value.
<>	Inequality	Test inequality of two values.
( )	Evaluate Expression	Evaluate the bracketed expression before applying operators to it.

Supported values

Data Types supported:

•

Numbers: including decimals and negative numbers.

•

Strings: any sequence of characters between two quotes.

•

Date time values: strings with any of these formats: "MM/DD/YYYY" or "MM/DD/YYYY HH:MM:SS".

•

Boolean: true or false values.