is_error

Evaluates to true if value is an error.

Syntax

is_error(value)

Parameters

• value and can be an expression must be either numbers, text, or boolean.

Examples

• Returns "1.067,30" if that’s a valid numeric format for the advertiser. Otherwise, it converts "1.067,30" to a valid format:

  if(

     is_error(to_number("1.067,30")),

     substitute(

        substitute("1.067,30", ".", ""),

        ",", "."), 

     "1.067,30"

  )

• Returns true if the number format is invalid for the current advertiser:
  Is_error(to_number("1.0,67"))
• Returns true if the specified formula column is invalid for the current context:
  Is_error(c:”PLARevenue”)

Related links

• Use functions in custom columns
• if
• or
• not
• and
• if_error
• if_not_finite
• is_not_finite