Filter Conditions for Numbers

Updated

You can use a single operator or combinations of operators to filter the numeric data that appears in reports.

The following table displays examples of operators and the expected results.

Example

Expected Result

>500

All values that are greater than 500.

<500

All values that are less than 500.

=1000

All values that are equal to 1,000.

>=50000

All values that are greater than or equal to 50,000.

<=1000

All values that are less than or equal to 1,000.

>50000 && <60000

All values that are between 50,000 and 60,000.

>100 && <500 || >50000 && <60000

All values that are either between 100 and 500 or between 50,000 and 60,000.

>100 && <500 || =59191

All values that are either between 100 and 500 or equal to 59,191.