EnableNullFactsInComputedItems (Property)

Applies To:

Pivot Section object

Description:

Enables Interactive Reporting to evaluate a null fact value (an empty cell value) as a zero fact value for non-Moving functions. For Moving Function calculations, where the presence of all displayed Fact cell must be considered in calculations, the number of instances of null values are subtracted from the Window divisor.

Exponential Moving Averages treat missing source fact values as having a value of zero.

When this option is disabled, the Pivot Sections that receive their data from a relational Query Section, ignore fact cells with null data when calculating Computed Items. That is, the calculation is simply skipped for the null cell.

Action:

Read-write, Boolean

Example:

This examples shows how to enable null fact values for computed items:

ActiveDocument.Sections["Pivot"].EnableNullFactsInComputedItems = true