Operator

index 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] ans 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