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
