---
title: Operator
slug: operator
docTags: 
createdAt: 2023-09-12T08:22:35.783Z
---

### 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`