Null Check

The Null Check property indicates how to handle arithmetic operations that contain null values. When the null check is performed, null values are changed to zero in arithmetic calculations (+, -, *, and /).

The options for this property are as follows:

• Do nothing, which means that the database rather than the Analytical Engine handles arithmetic calculations including a null value
• Check in all queries
• Check in temporary table join only
• Use default inherited value

  This property can also be set at the report level, which overwrites the setting at the metric level.