Operator 
Description 
Add 
Calculates the sum of two values. 
Substract 
Calculates the difference of two values.

Multiply 
Multiplies its values.

MAX 
Display the highest value of the field you selected. 
MIN 
Display the lowest value of the field you selected. 
Divide 
Divides its values.

Exponentiation 
Raises a number to a power of a specified number.

Open Parenthesis 
Specifies that the expressions within the open parenthesis is evaluated first.

Close Parenthesis 
Specifies that the expressions within the close parenthesis is evaluated the last.

Abs 
Calculates the absolute value of a number. The absolute value of a number is the number without its positive or negative sign. 
Equals 
Evaluates if two values are equivalent. 
Not Equal To 
Evaluates if two values are not equivalent. 
Less Than 
Evaluates if a value is less than the value that follows this symbol. 
Greater Than 
Evaluates if a value is greater than the value that follows this symbol. 
Less Or Equal 
Evaluates if a value is less than or equal to the value that follows this symbol.

And 
Evaluates if two values or expressions are both true. Use this operator as an alternative to the logical function AND. 
Or 
Evaluates if at least one of multiple values or expressions is true. Use this operator as an alternative to the logical function OR. 




Was this article helpful to you?
Yes
No