---
description: >-
  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 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.  &#x20;

<table><thead><tr><th width="200">Numerical Operator </th><th>Definition</th></tr></thead><tbody><tr><td><strong>is</strong> </td><td><p>A specific value. Displayed results will exclude all other values.</p><p></p><p>E.g. Filter field "is" "1000" will exclude all results that are not "1000".  </p></td></tr><tr><td><strong>is></strong></td><td><p>Is greater than. Displayed results will be any value greater than the filter field input.</p><p></p><p>E.g. Filter field "is>" "1000" will display all results that are greater than "1000" but will exclude "1000" itself.</p></td></tr><tr><td><strong>is>=</strong></td><td><p>Is greater or equal to. Displayed results will be any value greater than or equal to the filter field input.</p><p></p><p>E.g. Filter field "is>=" "1000" will display all results that are greater than "1000" and include "1000" itself.</p></td></tr><tr><td>i<strong>s&#x3C;</strong></td><td><p>Is less than. Displayed results will be any value less than the filter field input.</p><p></p><p>E.g. Filter field "is&#x3C;" "1000" will display all results that are less than "1000" but will exclude "1000" itself.</p></td></tr><tr><td>i<strong>s&#x3C;=</strong></td><td><p>Is less than or equal to. Displayed results will be any value less than or equal to the filter field input.</p><p></p><p>E.g. Filter field "is&#x3C;=" "1000" will display all results that are less than "1000" and include "1000" itself.</p></td></tr><tr><td><strong>is between</strong></td><td><p>Toggling the "is between" operator filters a field for a value between two user defined inputs and will pop-up the following parameters:</p><p></p><p><img src="https://1800800006-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgjz9nFZqIwynK1SO4gz%2Fuploads%2Fld8HD3hMre4mrDKqcYKz%2Fimage.png?alt=media&#x26;token=319874cd-c869-454c-9289-7dd9ad801612" alt="" data-size="original"></p><p></p><ul><li>[inclusive] means the results include the value on the left and right in the filter field. E.g. <code>user input (left)&#x3C;= RESULT &#x3C;= user input (right)</code>  </li><li>(exclusive) means the results exclude the value on the left and right in the filter field. E.g. <code>user input (left)&#x3C; RESULT &#x3C; user input (right)</code></li><li>[right-exclusive) means the results include the value on the left, but excludes the value on the right in the filter field. E.g. <code>user input (left) &#x3C;= RESULT &#x3C; user input (right)</code></li><li>(left-exclusive] means the results include the value on the right, but excludes the value on the left in the filter field. E.g. <code>user input (left) &#x3C; RESULT &#x3C;= user input (right)</code></li></ul></td></tr><tr><td><strong>is null</strong></td><td>Displays results where the value associated "is null". </td></tr><tr><td><strong>is not</strong></td><td><p>Excludes a specific value. Displayed results will exclude the user defined specific value.</p><p></p><p>E.g. Filter field "is not" "1000" will exclude all results that are "1000".  </p></td></tr><tr><td><strong>is not between</strong></td><td><p>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. </p><p></p><p>Toggling the "is not between" operator filters a field for values outside two user defined inputs and will pop-up the following parameters:</p><p></p><p><img src="https://1800800006-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgjz9nFZqIwynK1SO4gz%2Fuploads%2FsxX2zXdxvLehk0i2pC5c%2Fimage.png?alt=media&#x26;token=5d07bc96-4167-4da9-bfe9-e464a55e8fcd" alt="" data-size="original"></p><p></p><ul><li>[inclusive] means the results exclude the user values on the left and right in the filter field. E.g. <code>EXCLUDED SEGMENT = user input (left) TO user input (right)</code> </li><li>(exclusive) means the results include the value on the left and right in the filter field, but excludes everything in between. E.g. <code>EXCLUDED SEGMENT = (user input (left) TO user input (right)) - (user input (left) AND user input (right))</code> </li><li>[right-exclusive) means the results exclude the value on the left, but includes the value on the right in the filter field. E.g. <code>EXCLUDED SEGMENT = (user input (left) TO user input (right)) AND user input (left)</code></li><li>(left-exclusive] means the results exclude the value on the right, but includes the value on the left in the filter field. E.g. <code>EXCLUDED SEGMENT = (user input (left) TO user input (right)) AND user input (right)</code></li></ul></td></tr></tbody></table>

