Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Null Processing Property

Overview

The Null Processing property specifies which action Analysis Services takes when it encounters a Null value.

Process

The NullProcessing Property on Measures can now be changed from the Edit Measure dialogue:

The possible Null Processing settings are:

Setting Description
Automatic (Default) Null values are treated as ZeroOrBlank
Error Null values are invalid.
Preserve Specifies that the Null value is to be preserved
ZeroOrBlank Specifies that the Null value is converted to zero (for numeric data types) or a blank string (for string data types).

Published:

Null Processing Property

Overview

The Null Processing property specifies which action Analysis Services takes when it encounters a Null value.

Process

The NullProcessing Property on Measures can now be changed from the Edit Measure dialogue:

The possible Null Processing settings are:

Setting Description
Automatic (Default) Null values are treated as ZeroOrBlank
Error Null values are invalid.
Preserve Specifies that the Null value is to be preserved
ZeroOrBlank Specifies that the Null value is converted to zero (for numeric data types) or a blank string (for string data types).

For an optimal Community experience, Please view on Desktop