The 40 numeric operators and methods listed here provide a numeric output based on numeric inputs. (An input may also include text methods that provide a numeric output, such as the [text1].Length * 2 +3 formula mentioned previously.)
Several numeric operators and methods can be combined into one complex formula you’re looking for a certain kind of output. An example is:
| Sqrt(Pow([num1],2)+Pow([num2],2)) |
This formula calculates the length of the hypotenuse of a right triangle.
When using two or more operator types in one formula, the order of precedence for the calculation is as follows:
- Unary (such as –[num1]
- Multiplicative
- Additive
- Relational
If parentheses are used, like those in methods like Max(), Min(), Truncate(), etc., the expressions within the parentheses are evaluated first.