Last Updated: 06 Jan 2020 12:07 by ADMIN
Rosen Vladimirov
Created on: 22 Jan 2014 10:06
Category: PivotGrid
Type: Feature Request
Add option to ignore null values in aggregates
Currently when you have null value in a cell, RadPivotGrid considers it as 0. This way when you apply some Aggregate Functions, like Average for example, the result may not be as expected. For example if you have the cells 10, null, 10 RadPivotGrid will show as total the value 6.67 (for Average function). You should be able to exclude null values, so the value 10 will be shown as average for the mentioned cells.

Available in the 2016 R2 release.
Vladimir Stoyanov
Posted on: 06 Jan 2020 12:07

Hello Siddeshwar,

You can set the IgnoreNullValues property of the PropertyAggregateDescription to True in order to achieve what you are going for. When the aggregate descriptions are added during runtime, you can handle the PrepareDescriptionForField event of the LocalDataSourceProvider and set the IgnoreNullValues property there.

You can find some more information about that along with an example in the following article: Adding Group Descriptions Collections.

Vladimir Stoyanov
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Posted on: 28 Dec 2019 15:14

How to ignore null values in aggregation when generating RadPivotGrid automatically from configuration panel.