Evaluates to true
if value
is an error.
Note: This function is only available in Templates and can’t be used in Reporting.
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