Get sum and average of selected items of a grid in alert / Field / popup

[Shashank]

Hi, 

I am having a requirement to get sum and average of selected items (cells of specific numeric columns) of a grid in either an alert , Field or popup

Such as in the below example I want to get the average and Sum of selected Frieght columns

eg: https://demos.telerik.com/aspnet-mvc/grid/selection

I am not able to find the event for selectable: "multiple cell"

And also I want to allow this feature only on numeric fields. Please suggest the possible solution for this.

 

[Stefan]

Hello, Shashank,

The desired result can be achieved using the change event, select and the dataItem methods to get the value of the selected cells. Then a column index can be used to get the selected column:

https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/events/change#change

https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/methods/select

https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/methods/dataitem

I made an example demonstrating this:

https://dojo.telerik.com/IqavuW

Please have in mind that the Grid selection can be made over every cell, and if the selection has to be restricted the developer have to programmatically remove the k-state-selected class from all cell that should not be selected.

I hope this is helpful.

Regards,
Stefan
Progress Telerik

[Shashank]

Thanks Stefan for the solution. It worked !!