COUNTBLANK function

This topic describes the formula syntax and usage of the COUNTBLANK function in the Data Quality Execute Formula transform.

Description

Counts the number of blank fields within a range.

Syntax

COUNTBLANK(range)

The COUNTBLANK function syntax has the following argument:

  • range Required. The range in which to count the blank fields.

Example

Table 1. Data record
Id First_Name Last_Name House_Number Street City Postal_Code
27 Lemon Chester Road London W64 5HY
Table 2. Count of empty values
Formula Description Result
COUNTA([Id]:[Postal_Code]) Non-empty fields in range of all seven fields in record. 2