The CountNull function counts the number of rows in a column that contains null values.
CountNull (numbers, break_col, break_value)
numbers references the column that contains the numbers on which the count of null values is calculated.
break_col is an optional parameter that references a break column.
break_value is an optional parameter that returns the count of null numbers column where value in break_col equals break_value.
If constant values in the break_value column are substituted for data items, dates and text strings must be enclosed in single quotes. |
The following examples show the results of inserting the CountNull function in three separate tables.
In this example, the CountNull function is used on the numeric column. The results are shown in the Computed column.
CountNull(Amount)