Amazon QuickSight
User Guide

 AWS Documentation » Amazon QuickSight » User Guide » Working with Data in Amazon QuickSight » Preparing Data » Working with Calculated Fields » Calculated Field Function and Operator Reference » Arithmetic and Comparison Operators

# Arithmetic and Comparison Operators

You can use the following arithmetic and comparison operators in calculated fields.

• Subtraction (-)

• Multiplication (*)

• Division (/)

• Equal (=)

• Not equal (<>)

• Greater than (>)

• Greater than or equal to (>=)

• Less than (<)

• Less than or equal to (<=)

• AND

• OR

• NOT

Equal (=) and not equal (<>) comparisons are case-sensitive. For example, if the condition is `state = 'WA'` and the value in the field is `wa`, those values are not considered to be equivalent.

You can determine the order in which operators are applied by using parentheses. For example, in the following statement:

``(5 + 7) * 3``

The addition statement is processed first, and then the result is multiplied by three, returning a value of 36.

In the following statement:

``5 + (7 * 3)``

The multiplication statement is processed first, and then the result is added to five, returning a value of 26.

## Examples

The following example uses multiple arithmetic operators to determine a sales total after discount:

``({quantity} * {sales amount}) - {discount amount}``

The following example uses multiple conditional operators to identify top customers in Washington or Oregon for a promotion:

``ifelse(((State = 'WA' OR State = 'OR') AND {Number of orders} > 10), 'Special offer', 'n/a')``