Numerical Filters
Some filter field operators are only applicable to numerical inputs, primarily values, and or amounts. E.g. when filtering for transactions above or below certain values.
Last updated
Some filter field operators are only applicable to numerical inputs, primarily values, and or amounts. E.g. when filtering for transactions above or below certain values.
Last updated
Some filter field operators are only applicable to numerical inputs, primarily values, and or amounts. E.g. when filtering for transactions above or below certain values.
| Numerical Operator | Definition |
|---|---|
is
A specific value. Displayed results will exclude all other values.
E.g. Filter field "is" "1000" will exclude all results that are not "1000".
is>
Is greater than. Displayed results will be any value greater than the filter field input.
E.g. Filter field "is>" "1000" will display all results that are greater than "1000" but will exclude "1000" itself.
is>=
Is greater or equal to. Displayed results will be any value greater than or equal to the filter field input.
E.g. Filter field "is>=" "1000" will display all results that are greater than "1000" and include "1000" itself.
is<
Is less than. Displayed results will be any value less than the filter field input.
E.g. Filter field "is<" "1000" will display all results that are less than "1000" but will exclude "1000" itself.
is<=
Is less than or equal to. Displayed results will be any value less than or equal to the filter field input.
E.g. Filter field "is<=" "1000" will display all results that are less than "1000" and include "1000" itself.
is between
Toggling the "is between" operator filters a field for a value between two user defined inputs and will pop-up the following parameters:
[inclusive] means the results include the value on the left and right in the filter field. E.g. user input (left)<= RESULT <= user input (right)
(exclusive) means the results exclude the value on the left and right in the filter field. E.g. user input (left)< RESULT < user input (right)
[right-exclusive) means the results include the value on the left, but excludes the value on the right in the filter field. E.g. user input (left) <= RESULT < user input (right)
(left-exclusive] means the results include the value on the right, but excludes the value on the left in the filter field. E.g. user input (left) < RESULT <= user input (right)
is null
Displays results where the value associated "is null".
is not
Excludes a specific value. Displayed results will exclude the user defined specific value.
E.g. Filter field "is not" "1000" will exclude all results that are "1000".
is not between
Unlike the "is between" which seeks to filter all data except for a specific segment, "is not between" seeks to include all data and exclude the user specified segment.
Toggling the "is not between" operator filters a field for values outside two user defined inputs and will pop-up the following parameters:
[inclusive] means the results exclude the user values on the left and right in the filter field. E.g. EXCLUDED SEGMENT = user input (left) TO user input (right)
(exclusive) means the results include the value on the left and right in the filter field, but excludes everything in between. E.g. EXCLUDED SEGMENT = (user input (left) TO user input (right)) - (user input (left) AND user input (right))
[right-exclusive) means the results exclude the value on the left, but includes the value on the right in the filter field. E.g. EXCLUDED SEGMENT = (user input (left) TO user input (right)) AND user input (left)
(left-exclusive] means the results exclude the value on the right, but includes the value on the left in the filter field. E.g. EXCLUDED SEGMENT = (user input (left) TO user input (right)) AND user input (right)
