Greater than and Greater than or equal to
These filter types are available for Number and Decimal field types.
Is greater than filter type
The Is greater than filter (also called "More than" in some tools) returns records where the field’s value is strictly more than the specified value (i.e. Is this value more than X?).
Example
You want to find customers who's amount spent is greater than 500.
- Field: Amount
- Filter: Is greater than 500
Matches:
- Amount = 200 ✅
- Amount= 400 ✅
- Amount = 500 ❌ (because it’s not more than, it’s equal)
Is greater than or equal to filter type
The Is greater than or equal to filter includes records that are more than or exactly equal to the specified value (i.e. Is this value more than or equal to X?).
Example
You want to find customers who's amount spent is greater than or equal to 500.
- Field: Amount
- Filter: Is greater than or equal to 500
Matches:
- Amount = 200 ✅
- Amount= 400 ✅
- Amount = 500 ✅ (because it’s equal to 500)