Custom Filter Operators for Numeric Fields

Numeric-filtering operations have the following requirements and restrictions:

For decimal and % values, the formatter rounds and truncates decimal places. Therefore, use the greater than and less than operators to find matches for these values.

Operator	Description
equals	Filters data where the value of the associated field is equal to the value entered.
not equal	Filters data where the value of the associated field is not equal to the value entered.
greater than	Filters data where the value of the associated field is greater to the value entered.
less than	Filters data where the value of the associated field is smaller than the value entered.
greater than or equal to	Filters data where the value of the associated field is greater than or equal to the value entered.
less than or equal to	Filters data where the value of the associated field is less than or equal to the value entered.
in	Looks for a match in a comma-separated list. Wildcards are not supported. Note: Do not include spaces after the commas in the comma-separated list.
not in	Returns data for values that are not in the comma-separated list. Wildcards are not supported for values in this list. Note: Do not include spaces after the commas in the comma-separated list.
is null	Checks for null values. This is a special operation that looks for the absence of values.
is not null	Checks for non-null values. This is a special operation that looks for values that are not null.