Description
Fills the BLANK values of a Metric with a given value.
Syntax
IFBLANK(Metric to Fill, Value)
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Metric to Fill (required) | Any | Any Dimensions | Metric to fill the BLANK. |
| Value (required) | Same Type as Metric to Fill | No Dimension or Dimensions of Metric to Fill | Value to fill the BLANK with. |
Returns
| Type | Dimensions |
|---|---|
| Same Type as Metric to Fill | Dimensions of Metric to Fill |
Examples
| Formula | Result | Description |
|---|---|---|
IFBLANK(1, BLANK) | 1 | 1 is not a BLANK value, there is nothing to fill. |
IFBLANK(BLANK, 1) | 1 | BLANK is replaced by 1. |
IFBLANK(1, 2) | 1 | 1 is not a BLANK value, there is nothing to fill. |
IFBLANK(BLANK, BLANK) | BLANK | BLANK is replaced by BLANK. |
See also
Related articles: ISBLANK
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!
