Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
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