Kendo MVC Grid : How to create new column and its value is multiply of 2 other columns

[Pham]

Hello Telerik team

 I use Kendo MVC grid. My grid "Price", "Quantity" column. I want to add one more column "Total (Price*Quantity)" column. "Total (Price*Quantity)" column

 = "Price"*"Quantity".

- I don't want to generate "Total (Price*Quantity)" column in .

-  How to use Aggregates to create "Total (Price*Quantity)" column in

Thanks and Best regards

[Alexander Popov]

Hi Pham,

The simplest approach would be to use a column template in which the calculation is done. This approach however will not allow you to perform any aggregations, because the calculation is done each time the Grid is redrawn and the  "Total (Price*Quantity)"  does not really exist in the DataSource. Another approach you might use is generating the field in the DataSource's schema.parse function.

Regards,
Alexander Popov
Telerik

 

 

[Pham]

I solved it. This is my solution 

columns.Template(c => c.Quantity * c.Price).Title("Total (Price*Quantity)").ClientTemplate("#: Quantity*Price #");

Thank you.