create third column in kendo grid with de sum of column one and two.

[Yonatan]

I want the sum of two columns to be added to another column in the kendo grid. Now it is showing that NaN when I use ClientTemplate whereas in the case of ClientGroupColumnTemplate shows the correct result. In my case, I want the result in another column instead of a group column any help?

.Columns(c =>

    {  c.Bound(p => p.field1).Title("F1");
       c.Bound(p => p.field2).Title("F2");
       c.Bound(p => p.Total).Title("Total").ClientTemplate("#=calculate(data)#");
})

<script>
    function calculate(data) {
        field1 + p.field2;
        return result;

</script>

[Anton Mironov]

Hello Yonatan,

Thank you for the code snippet and details provided.

In order to achieve the desired behavior, I would recommend trying the following implementation for the "Total" column:

columns.Template(c => { }).ClientTemplate("#=calculateField(data)#").Title("Total");

And the JavaScript function:

    function calculateField(data) {
        return data.Field1 + data.Field2;
    }

Attached is a sample project that I prepared for the case. It includes the approach above.

Make the needed tests locally with the project attached and let me know if further assistance is needed.

 

Kind Regards,
Anton Mironov
Progress Telerik

[Yonatan]

Thank you, Anton Mironov, It works perfectly. 

[Anton Mironov]

Hi Yonatan,

I am glad to hear that the required behavior is now achieved.

If further assistance for anything else Kendo-related is needed, do not hesitate to contact me and the team.

Best Regards,
Anton Mironov