More information
Arithmetic Operators
Below is a list of arithmetic operators available in the system and the order in which Custom Columns perform operations in formulas:
- Parentheses ( )
- Multiply *
- Divide /
- Add +
- Subtract –
When two operators in an expression have the same operator, the system reads them left to right based on their position in the expression. Parentheses override the defined precedence of the operators in an expression. Everything within the parentheses is evaluated first to create a single value before that value is used by an operator outside of the parentheses. If an expression has nested parentheses, the most deeply nested expression is evaluated first.