XRGroupSortingSummary.IgnoreNullValues Property
Specifies whether null values should be ignored when a summary is calculated.
Namespace: DevExpress.XtraReports.UI
Assembly: DevExpress.XtraReports.v19.1.dll
NuGet Packages: DevExpress.Reporting.Core, DevExpress.WindowsDesktop.Core
Declaration
[DefaultValue(false)]
[SRCategory(ReportStringId.CatBehavior)]
public bool IgnoreNullValues { get; set; }Property Value
| Type | Default | Description |
|---|---|---|
| Boolean | **false** | true to ignore null values; otherwise, false. |
Remarks
Use this property to specify whether null values should be ignored when a summary is calculated. If they are included they will be treated as zeros. For instance, for the SortingSummaryFunction.Avg summary function and the following set of values:
1, null, 5
with the IgnoreNullValues = true the Average function’s value will be 3, and
with the IgnoreNullValues = false the Average function’s value will be 2.
To learn more, see Grouping and Sorting a Report’s Data.