IPivotEvaluatorTotals.TreatEmptyAsZero

Syntax

TreatEmptyAsZero: Boolean;

Description

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

Comments

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

Example

TreatEmptyAsZero := False;

TreatEmptyAsZero := True;