Display sum of column in grid footer

[sandy]

Hi,

i have few integer columns in grid.

I want to display sum of column in footer of the grid.

i tried several ways but could not success.

[Petar]

Hi Sandy,

Attached to my reply, you will find a runnable example demonstrating how we can add a footer template that sums the data of a given Grid column. Here is the used Grid definition:

@(Html.Kendo().Grid<GridSum.Models.OrderViewModel>()
    .Name("grid")
    .Columns(columns =>
    {
        columns.Bound(p => p.OrderID).Filterable(false);
        columns.Bound(p => p.Freight).ClientFooterTemplate("Sum : #=sum#");
        columns.Bound(p => p.OrderDate).Format("{0:MM/dd/yyyy}");
        columns.Bound(p => p.ShipName);
        columns.Bound(p => p.ShipCity);
    })
    .Pageable()
    .Sortable()
    .Scrollable()
    .Filterable()
    .HtmlAttributes(new { style = "height:550px;" })
    .DataSource(dataSource => dataSource
        .Ajax()
        .PageSize(20)
        .Aggregates(aggregates =>
        {
            aggregates.Add(p => p.Freight).Sum();
        })
        .Read(read => read.Action("Orders_Read", "Grid"))
    )
)

With the code in yellow, we define the FooterTemplate of the "Freight" column. With the code in green, we define the "sum" aggregate for the "Freight" column.

In the attached example, the "sum" displayed in the footer template is the sum of all fields in the "Freight" column. If you want to display only the sum of the fields that are loaded in the current Grid page, you can check this SO thread. 

I hope the provided example will help you implement the targeted functionality in the application you are working on.

Regards,

Petar
Progress Telerik

[Stefan]

This is not working when a row contains a null value

[Mihaela]

Hi Stefan,

Would you check data type of the Model property, which aggregate is displayed within the Grid footer? The default value of the integral numeric and floating-point numeric types (i.e., integer, double, decimal, etc.) is 0 (zero). 

I have tested the "Freight" property, which data type is decimal, and it appears that the "sum" aggregate is correct:

Best,

Mihaela