Show AllShow All

Examples of expressions that use arithmetic operators

Arithmetic 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