​​​Description
Counts the number of BLANK values of a Block.
Syntax
COUNTBLANKOF(Block)
Arguments
Argument | Type | Dimensions | Description |
|---|---|---|---|
Block (required) | Any | Any |
Returns
Type | Dimensions |
|---|---|
Integer | No Dimension |
Examples
Employee is a Dimension List:
Formula | Result | Description |
|---|---|---|
| 0 | For a List, no item is counted as |
| 1 | The Property Name contains 1 |
See also
Excel: COUNTBLANK
Related articles: COUNTALLOF, COUNTOF, COUNTUNIQUEOF
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!