Filter by numeric fields

Numeric fields don’t have implicit filters in Better Reports — you’ll always need to add your own. These filters let you narrow results to rows that match, exceed, fall below, or are missing numeric values.

You can identify numeric fields by the 123, $ or % icons beside the field name in the report builder.

In this article:

• Equal / Not equal
• Greater than / Greater than or equal
• Less than / Less than or equal
• Is in / Is not in
• Is known / Is unknown
• Need more support?

To learn how to add a filter, see Filter a report.

Equal / Not equal

Equal (=) shows rows where the field matches the exact numeric value you enter.

• Example: Filtering Quantity = 10 returns only rows where the quantity is exactly 10.

Not equal (≠) excludes rows with the value you enter.

• Example: Filtering Quantity ≠ 10 returns all rows except those with a quantity of 10.

Greater than / Greater than or equal

Greater than (>) shows rows with values larger than the number you enter.

• Example: Filtering Quantity > 100 returns rows where the quantity is 101 or more.

Greater than or equal (≥) includes the number itself as well.

• Example: Filtering Quantity ≥ 100 returns rows where the quantity is 100 or more.

Less than / Less than or equal

Less than (<) shows rows with values smaller than the number you enter.

• Example: Filtering Quantity < 50 returns rows where the value is 49 or less.

Less than or equal (≤) includes the number itself as well.

• Example: Filtering Quantity ≤ 50 returns rows where the value is 50 or less.

Is in / Is not in

Is in lets you provide multiple numeric values. Rows will show if they match any of the values.

• Example: Filtering Quantity is in 10, 20, 30 returns rows with a quantity of 10, 20, or 30.

Is not in excludes rows that match any of the provided values.

• Example: Filtering Quantity is not in 10, 20, 30 returns rows where the quantity is anything other than 10, 20, or 30.

Is known / Is unknown

These operators check whether a numeric field contains a value.

• Is known shows only rows where the field has a value.
• Is unknown shows only rows where the field doesn’t have a value (NULL or empty).