Fields/Field types/Formula
Numeric and Logical Operators
This article explains various numeric and logical operators that can be used in formula fields.
Numeric operators
| Operator | Sample | Description |
|---|---|---|
+ | {field1} + {field2} + 2 | Addition of numeric values |
- | {field1} - {field2} | Subtraction of numeric values |
* | {field1} * {field2} | Multiplication of numeric values |
/ | {field1} / {field2} | Division of numeric values |
:::tip
To change the order of arithmetic operation, you can use round bracket parenthesis ().
Example: ({field1} + ({field2} * {field3}) / (3 - {field4} ))
:::
Logical operators
| Operator | Sample | Description |
|---|---|---|
< | {field1} < {field2} | Less than |
> | {field1} > {field2} | Greater than |
<= | {field1} <= {field2} | Less than or equal to |
>= | {field1} >= {field2} | Greater than or equal to |
== | {field1} == {field2} | Equal to |
!= | {field1} != {field2} | Not equal to |
String operators
| Operator | Sample | Description |
|---|---|---|
& | {field1} & {field2} | String concatenation |