NullToEmpty

Converts a value of NULL to an empty string. If the value is not NULL, the original value is kept.

Syntax

NullToEmpty(Argument)

Where:

Argument is metric or attribute form.

Example

You can use NullToEmpty when creating derived attributes to convert NULL values for attribute elements to empty strings. For example, you can convert NULL values to empty strings so that attribute element values can be successfully concatenated with functions such as Concat (see Concat (Concatenate)) or ConcatBlank (see ConcatBlank (Concatenate Plus Blank Space)).

For steps to create derived attributes, see the MicroStrategy Web Help.