Sign Up for Training |
Jet Global Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Null Processing Property


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


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).
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request