BLANK_VALUE
Description
Returns a substitute value if the provided value is blank or empty; otherwise, returns the original value.
Syntax
BLANK_VALUE(value, substitute_value) -> Object
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| value | Object | Yes | The value to evaluate. |
| substitute_value | Object | Yes | The substitute value to return if the provided value is blank. |
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.