Analysis Expert uses operators to determine what data to display. The following table explains what each operator means.
Symbol
Read as
Explanation of Result
=
equals
Will display records where the field’s value is equal to the value specified. Note that only exact matches will be displayed.
>=
is greater than or equal to
Will display records where the field’s value is greater than or equal to the value specified. This operator is only available for criteria with numerical values, such as dates, quantities, amounts of money, etc.
<=
is less than or equal to
Will display records where the field’s value is less than or equal to the value specified. This operator is only available for criteria with numerical values.
>
is greater than
Will display records where the field’s value is greater than the value specified. This operator is only available for criteria with numerical values.
<
is less than
Will display records where the field’s value is less than the value specified. This operator is only available for criteria with numerical values.
<>
is not equal to
Will display records where the field’s value is not equal to the value specified.
Like
like
Will display records where the value specified is contained somewhere in the selected field.
Starts with
starts with
Will display records where the field’s value starts with the value specified.
Ends with
ends with
Will display records where the field’s value ends with the value specified.
Between
between
Will display records where the field’s value is between the dates specified.
Not Between
not between
Will display records where the field’s value is not between the dates specified.
Today
today
Will display records where the field’s value is today’s date.
Yesterday
yesterday
Will display records where the field’s value is yesterday’s date.
This Week
this week
Will display records where the field’s value contains records from this week.
This Month
this month
Will display records where the field’s value contains records from this month.
This Year
this year
Will display records where the field’s value contains records from this year.
Last # Days
last # days
Will display records where the field’s value contains records from the last specified number of days. Will not display the day you are currently in.
Last # Weeks
last # weeks
Will display records where the field’s value contains records from the last specified number of weeks. Will not display the week you are currently in (reads as Sunday-Saturday).
Last # Months
last # months
Will display records where the field’s value contains records from the last specified number of months. Will not display the month you are currently in.
Last # Years
last # years
Will display records where the field’s value contains records from the last specified number of years. Will not display the year you are currently in.
Is Empty
is empty
Will display records where the field’s value is N/A. Using the operator is empty will lock (make uneditable) the Value field.
