Mathematical operators perform arithmetic computations.
Symbol | Name | Definition |
+ | Plus | Adds two values |
- | Minus | Subtracts the second value from the first |
* | Multiply | Multiplies each value |
/ | Divide | Divides the first value by the second |
^ | Power Of | Raises the first value to the power of the second value |
( ) | Precedence | FileMaker Pro Advanced evaluates formulas from left to right, performing multiplication and division before addition and subtraction. Using parentheses lets you change the order: FileMaker Pro Advanced evaluates expressions between parentheses first. See Using operators in formulas. |