Data Engine Syntax

This section describes formula syntax when using Data Engine Syntax mode.

•

Fields/Columns—Use [ ] around the field or column name. For example:

[Sales]

•

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

sum([Items]) or avg([Temp])

•

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

Available Operators

Symbol	Operation	Description
.	Apply	Apply the function following the dot to the string/text value before the dot.
*	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.
^	Exclusive Or	Bitwise exclusive or (XOR) of two values.
AND	And	Logical and of two values.
OR	Or	Logical or of two values.
NOT	Not	Logical not of a value.
( )	Evaluate Expression	Evaluate the bracketed expression before applying operators to it.