Create calculated value for Grid

[Jeff]

I have a data source returning Units and Price.  I need to create a column, Extende Price, in a grid to display:

Units    | Price | Extended Price (Units * Price)

I can't see how I can do this.

Jeff

[Mat]

You need to create a 'fake' column. Something along the lines of:
columns: [
                { field: "units", title: "Units" },
                { field: "price", title: "Price" },
                { field: null, title: "Extended Price", template: '#= units * price #' }
            ]

Regards,
Mat

[Hammad]

How can i set the value of a field in a model?

I have almost same scenario like @poster

ProductID | Quantity | UnitPrice | TotalPrice

in the save event of Grid, i am using jQuery ajax call to update quantity to the server. After that i need to update the Total Price

I am trying:

$("#cart_results").kendoGrid(
{
    //some config of grid,
    //save event handler
    save: function (e)
    {
         //after my ajax call
         e.model.set("TotalPrice",e.model.UnitPrice * e.values.Quantity);
    }
    //some other config of grid
}

but it still shows old value of TotalPrice

Console of Safari shows no errors

I dont want a calculated column

[quaso]

Try to update the datasource instead of the model:


$("#cart_results").kendoGrid(
{
    //some config of grid,
    //save event handler
    save: function (e) 
    {
         //after my ajax call
        this.dataSource.getByUid(e.model.uid).set("TotalPrice",e.model.UnitPrice * e.values.Quantity); 
    }
    //some other config of grid
}