Operator
Returns the content of an array at a given index, starting from 1.
Syntax
INDEX(array, index)
 array: A reference to a property containing a list of values.
 index: The index of the element in array that needs to be returned, starting from 1.
Sample Usage
INDEX(numbers, 1)
 Returns 1 for numbers = [1, 2, 3]

Returns the previously computed value for the current property.
Syntax
ANS()
Sample Usage
COALESCE(ANS(), TODAY())
 Keeps the creation date regardless of how many times the value gets recomputed.
Returns the sum of two numbers.
Syntax
value1 + value2
 value1: The first addend.
 value2: The second addend.
Sample Usage
property1 + 3
3 + 4
Returns TRUE if two specified values are equal and FALSE otherwise.
Syntax
value1 = value2
 value1: The first value.
 value2: The value to test against value1 for equality.
Sample Usage
property = "xyz"
2 = 3
Returns the concatenation of two values.
Syntax
value1 & value2
 value1: The value to which value2 will be appended.
 value2: The value to append to value1.
Sample Usage
property & 12
"Mr. " & name
Notes
 value1 and value2 can be any scalar value or reference to a scalar value, including numeric and text types.
Returns one number divided by another.
Syntax
dividend / divisor
 dividend: The number to be divided.
 divisor: The number to divide by (cannot equal 0).
Sample Usage
4 / 2
number1 / number2
Returns a number raised to a power.
Syntax
base ^ exponent
 base: The number to raise to the exponent power. If base is negative, exponent must be an integer.
 exponent: The exponent to raise base to.
Sample Usage
4 ^ 0.5
property1 ^ property2
Returns TRUE if the first argument is strictly greater than the second, and FALSE otherwise.
Syntax
value1 > value2
 value1: The value to test as being greater than value2.
 value2: The second value.
Sample Usage
property > 2
3 > 1
Returns TRUE if the first argument is greater or equal than the second, and FALSE otherwise.
Syntax
value1 >= value2
 value1: The value to test as being greater or equal to value2.
 value2: The second value.
Sample Usage
property >= 2
3 >= 1
Returns TRUE if the first argument is strictly less than the second, and FALSE otherwise.
Syntax
value1 < value2
 value1: The value to test as being less than value2.
 value2: The second value.
Sample Usage
property < 2
3 < 1
Returns TRUE if the first argument is less than or equal to the second, and FALSE otherwise.
Syntax
value1 <= value2
 value1: The value to test as being less than or equal to value2.
 value2: The second value.
Sample Usage
property <= 2
3 <= 1
Returns the product of two numbers.
Syntax
factor1 * factor2
 factor1: The first multiplicand.
 factor2: The second multiplicand.
Sample Usage
property * 2
2 * 3
Returns TRUE if two specified values are not equal and FALSE otherwise.
Syntax
value1 <> value2
 value1: The first value.
 value2: The value to test against value1 for inequality.
Sample Usage
property1 <> property2
2 <> 3
Returns the difference of two numbers.
Syntax
value1  value2
 value1: The minuend, or number to be subtracted from.
 value2: The subtrahend, or number to subtract from value1.
Sample Usage
property1  property2
3  4