Filters: Condition operators in modern reports

You can use the following operators when you create conditions for modern report filters.

Logical Operator	Description	Field Type
Has value	True if the field has a value.	All supported field types except Allocation.
Has no value	True if the field does not have a value.	All supported field types except Allocation.
Is	True if the field equals the specified value.	All supported field types.
Is not	True if the field does not equal the specified value.	All supported field types.
Is after	True if the field is after the specified date.	Date
Is on or after	True if the field is on or after the specified date.	Date
Is before	True if the field is before the specified date.	Date
Is on or before	True if the field is on or before the specified date.	Date
Contains	True if part of the field matches.	Short Answer Long Answer Email Zip / Postal Code Phone Number
Does not contain	True if the field does not match.	Short Answer Long Answer Email Zip / Postal Code Phone Number
Starts with	True if the beginning of the field matches.	Short Answer Long Answer Email Zip / Postal Code Phone Number
Ends with	True if the end of the field matches.	Short Answer Long Answer Email Zip / Postal Code Phone Number
Greater than	True if the field is more than the value specified.	Number Allocation
Greater than equal to	True if the field is equal to or more than the value specified.	Number Allocation
Less than	True if the field is less than the value specified.	Number Allocation
Less than equal to	True if the field is equal to or less than the value specified.	Number Allocation

Related information

• Create and apply a filter to a modern report
• Filter examples for modern reports