How to sum a dropdownlist column in grid

[Bing]

Hi guys

I define a dropdownlist in the grid, how can I sum this column based on the data-text-field of this dropdown list?

Thanks
Bing

[Alexander Valchev]

Hi Bing,

I am afraid I cannot understand what you are trying to achieve. Could you please provide more details about your scenario and if possible an example?

Thank you in advance for your cooperation.

Greetings,
Alexander Valchev
the Telerik team

[Bing]

Hi Alexander

Thanks For your reply.
I will try explain more detail.
I need show sum on the group footer on a grid.

I create a kendoGrid column binding with a dropdown list

{ field: Mon", title: "Mon", template: "#=Mon.HourText#", groupFooterTemplate: "#=sum#", width: 80, editor: hoursDropDownEditor },

The dropdown list is created by
function hoursDropDownEditor(container, options) {
$('<input data-text-field="HourText" data-value-field="HourID" data-change="HoursChange" data-bind="value:' + options.field + '"/>').appendTo(container).kendoDropDownList({
autoBind: false,
dataSource: {
data: hours
 },
 dataTextField: "HourText",
 dataValueField: "HourID",
 optionsCaption: "Choose..."
 });
 }

The datasource
var hours = [
{ HourText: "0.5", HourID: "0" },
{ HourText: "1", HourID: "1" },
{ HourText: "2", HourID: "2" },
{ HourText: "3", HourID: "3" },
{ HourText: "4", HourID: "4" },
{ HourText: "5", HourID: "5" },
{ HourText: "6", HourID: "6" },
{ HourText: "7", HourID: "7" },
{ HourText: "8", HourID: "8" },
{ HourText: "9", HourID: "9" },
{ HourText: "10", HourID: "10" }
];

 

 

[Alexander Valchev]

Hello Bing,

In order to display the sum of the field, I would suggest to define the column aggregates. Please check the following example:

{
    field: "Mon",
    aggregates: "sum",
    editor: categoryDropDownEditor,
    groupFooterTemplate: "Group sum: #=sum#"
}

I hope this information will help.

Regards,
Alexander Valchev
the Telerik team