Show AllArithmetic operators perform basic mathematical operations, such as addition, subtraction, multiplication and division, and produce numeric results. You can use arithmetic operators in an expression in the Criteria pane or in a calculated field.
| Arithmetic operator |
Meaning |
Example |
Syntax |
|---|---|---|---|
| + (plus sign) | Addition | Total payment due from a customer | Order_Amt+Freight |
| – (minus sign) | Subtraction | Total price of an order, including any discount | Order_Amt-Discount |
| * (asterisk) | Multiplication | Total order amount for a specific product | Unit_Price*Quantity |
| / (forward slash) | Division | Price per unit | Order_Amt/Quantity |