Filter empty fields

Sometimes, you may want to know if a data field contains a value or is empty. For example, you only want to display fields that are not empty. Empty data fields are not always actually empty; sometimes they contain a certain kind of null information. Therefore, it is advisable to use a special syntax to filter for fields with actual content.

To exclude empty strings, use the following expression:

Expression for excluding empty strings

Expression	Operation	Value
=fieldname <> ""	=	=True

To exclude empty numbers, use one of the following expressions:

Expression	Operation	Value
=fieldname	>	=0