Function

a!defaultValue( value, default )

Returns a default value when the specified value is null or empty. When there are multiple default parameters, each parameter is evaluated in order and the first non-null and non-empty default will be returned. Null, "", and {} are all considered null or empty values.

See also: if(), isnull()

Parameters

Returns

Any Type

Usage considerations

Using default values

• This function accepts multiple default parameters, and each parameter will be evaluated in order until the first non-null and non-empty default is returned. For example, a!defaultValue("", null, "N/A") returns "N/A".
• If you add a list of values as a default value, they will be treated as a single value. For example, a!defaultValue({1, null, 3}, 4) would return {1, null, 3}.
  • A list of nulls or empty text are not considered null or empty. For example, a!defaultValue({null, null, null}, 3) returns {null, null, null}, and a!defaultValue({"", "", ""}, 3) returns {"", "", ""}.
  • An empty list is considered null or empty. For example, a!defaultValue({}, 3) returns 3.

Examples

Basic

1
a!defaultValue(null, 1)

Returns 1.

1
a!defaultValue(1, "default")

Returns 1.

Using null or empty values

1
a!defaultValue("", "default")

Returns "default".

1
a!defaultValue(null, "")

Returns "".

1
a!defaultValue({}, "default")

Returns "default". An empty list is considered null or empty.

Using multiple default parameters

This function accepts multiple default parameters. Each parameter will be evaluated in order until the first non-null and non-empty default is returned.

1
a!defaultValue(null, "", {})

Returns {}.

1
a!defaultValue(null, "", 1, "", {})

Returns 1.

Using lists

1
a!defaultValue({1, 9}, {2, 3, 4, 5})

Returns {1, 9}. A list of values is treated as a single value of type list.

1
a!defaultValue({null, null}, {3})

Returns {null, null}. A list of nulls is not considered null or empty.

1
a!defaultValue({"", "", ""}, {3})

Returns {"", "", ""}. A list of empty text is not considered null or empty.

1
a!defaultValue({​{1,2,3}, {4,5}}, "default")

Returns {1, 2, 3, 4, 5}. Lists of lists are flattened.

1
a!defaultValue(null, {2, {3, 4}, 5})

Returns {2, 3, 4, 5}. Lists of lists are flattened.

Feature compatibility