Filtering empty or null values Sometimes cross tabs have missing data. Consider a customer database that contains an e-mail field. For customers who did not supply an e-mail address, the e-mail field is empty or blank. An empty value, also called a null value, means that no value is available. Null values apply to all data types. You can create a filter to exclude data when a specific field has null values. When filtering to exclude rows containing null values, use the Is Not Null operator. If you want to view only rows with null values in a particular field, use the Is Null operator. For example, the following filter condition excludes customer data where the ProductLine field contains null values: ProductLine Is Not Null The following filter condition displays only rows where the ProductLine field contains null values: ProductLine Is Null
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy
