Revision 1 79 9/10/2019
Six numerical operators can be used to filter the data (Table 5-9).
Table 5-9: Data Sorting Operators
Than
When this operator is used in conjunction with a number, the
data will be filtered such that only data greater in value than the
number entered will be displayed. For example, if the
expression “>1000” was entered into the dialog box, the
column will be filtered such that only data with values greater
than 1000 will be displayed.
When this operator is used in conjunction with a number, the
data will be filtered such that only data lower in value than the
number entered will be displayed. For example, if “<1000” was
entered into the dialog box, the column will be filtered such that
only data with values less than 1000 will be displayed.
When this operator is used in conjunction with a number, the
data will be filtered such that only data that is EXACTLY equal
to the number entered will be displayed. For example, if
“=1000” was entered into the dialog box, only data exactly
equal to 1000 will be displayed.
Digits
When this operator is used in conjunction with a number, the
data will be filtered such that only data ending in the number
entered will be displayed. For example, if “*25” was entered,
the column will be filtered such that only data ending in 25 (e.g.
9.2929292925, 1.00000025, etc) will be displayed.
When this operator is used to join a string of numbers together,
the data will be filtered such that only data being exactly equal
to each number in the string will be displayed. For example, if
the expression “1^5^7^12” was entered into a list of data
containing the whole numbers from 1 to 20, the only numbers
in the list that would pass through this filter would be the
functions
fulfilled
When this operator is used to join two or more other operators
in a string, the data will be filtered such that only data that
fulfills all of the operators’ conditions will be displayed. For
example, if the user wished to display all of the data with values
between 7 and 8, they could type “>7&<8” into the dialogue
box. Note, of course, that this would filter out values of exactly
To Next Page
Loading...
