IPivotEvaluatorTotals.TreatEmptyAsZero

Syntax

TreatEmptyAsZero: Boolean;

Description

The TreatEmptyAsZero property determines whether empty values are treated as zero values.

Comments

The property is relevant while calculating specified totals types that consider the number of elements in a period, for example, Average. The property is set to False by default, and empty values are not considered while calculating totals.

Example

TreatEmptyAsZero := False;

TreatEmptyAsZero := True;

See also:

IPivotEvaluatorTotals