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.
It’s like asking: “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.
It’s like asking: “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)
Available for field types: Number, Decimal
To know more on how to use these filter types, you can watch this video.
Comments
0 comments
Please sign in to leave a comment.