Operators

Analytics Pro supports basic operators for calculations, evaluating them in accepted order. You can use these operators when developing the conditions of Logical Functions

Analytics Pro supports the following operators:

Example

When calculating values, such as using the addition operator + to add two values, the result is Null if one of the values is Null.

[Column 1] + [Column 2]

If the value of [Column 2] is Null, then the result of the entire formula is Null.

To resolve this, you can apply the Zn function to each value, to substitute 0 for Null:

Zn([Column 1]) + Zn([Column 2])

-	Subtracts one number from another
+	Adds two numbers
*	Multiplies two numbers
/	Divides one number by another
^	Raises a number to the specified power
%	Modulo computes the remainder of dividing X by Y
&	Ampersand concatenates two strings together
<	Determines if X is less than Y
<=	Returns whether X is less than or equal to Y
>	Returns whether X is greater than y
>=	Returns whether X is greater than or equal to y
=	Returns whether x is equal to y
!=	Returns whether x is not equal to y
()	Used to change the order of operations
AND	Returns whether two logical values are both TRUE
OR	Returns whether either of two logical values are TRUE
NOT	Negate a value or expression
TRUE	Interpreted as the Boolean literal TRUE
FALSE	Interpreted as the Boolean literal FALSE
NULL	Interpreted as a null literal
.	Class division notation. Used to navigate through the levels of Variant and JSON data types