U.M. (Windows)

2-16 FileMaker Pro User’s Guide
Each operator has a precedence, which determines the order in which
calculations are performed in a formula containing more than one
operator. FileMaker Pro evaluates operators from left to right and
performs multiplication and division before addition and subtraction.
You can change the precedence by enclosing the expression you want
calculated first in parentheses.
Mathematical operators
Use the following mathematical operators with numeric expressions.
This expression Returns
2+3*2 8
(2+3)*2 10
Choose FileMaker Help Index from the Help menu, and then type:
E operators
Symbol Name Definition Examples
+ Addition Adds two values 2+2
Subtotal+Sales Tax
– Subtraction or
Negation
Subtracts the second
value from the first, or
changes the sign to + or
–
2–2
InvoiceTotal–Discount
–2
* Multiplication Multiplies each value Subtotal*Sales Tax
DaysLate*.01*LeasePayment
/ Division Divides the first value
by the second
Kilometers Driven/Liters
Inches/12
^ Power of, or
Exponentiation
Raises the first value to
the power of the second
value
A^2+B^2 returns (A
2
+ B
2
)
Radius^3 returns (Radius
3
)
Choose FileMaker Help Index from the Help menu, and then type:
E mathematical operators
?
?