Zero Check

The Zero Check property indicates how to handle division by zero and when to check for zeros in the denominator during division. When a zero check is performed, a zero in the denominator of a division calculation is changed to a null value.

The options for this property are as follows:

• Do nothing, which means that the database rather than the Analytical Engine handles division by a zero
• 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.