Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

How to Control the NullProcessing Property on Measures


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 illegal
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

Comments