IFBLANK function

  • 21 December 2021
  • 0 replies
  • 1207 views

Userlevel 5
Badge +8

​​​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!

 

 


This topic has been closed for comments