BLANK_VALUE
Description
If the value is blank, evaluates the substitute values in order and returns the first non-blank value; otherwise, returns the original value. A value is considered blank if it is NULL, empty, contains only whitespace, or evaluates to $SKIP_ASSIGNMENT.
Syntax
BLANK_VALUE(value, ...substitute_value) -> Object
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| value | Object | Yes | The value to evaluate. |
| ...substitute_value | Object | Yes | One or more substitute values to fall back on when the provided value is blank; the first one that is not blank is returned. |
Examples
BLANK_VALUE("", "N/A")
-- Returns "N/A".BLANK_VALUE(Rating, "No Data")
-- Returns "No Data" if Rating is NULL or blank; otherwise, returns Rating.