[Solved] Subtract Aggregate Result from Model Field

[Ezequiel]

Hello.

I have a page with a Model with some data and then a editable grid with some items of this Model. The Grid data is Ajax binded.

columns.Bound(c => c.Price) .Width(85)
.Aggregate(aggregates => aggregates.Sum())
.ClientFooterTemplate("<#= $.telerik.formatString('{0:0,0.0}', Sum)#>")
 .HtmlAttributes(new { style = "text-align:right" });

I have an aggregate footer which sums one of the columns, but I need to subtract this total from a field in the Model.

it would be something like  (the above sum - Model.Cost).

columns.Bound(p => p.Description).FooterTemplate(() =>
{%>
            Total:<%= string.Format("{0:c}", (###Aggregate Sum###  -  Model.TotalCost)%>
 <%});

when I change some price, I would need to reload the value of this last calculation.
How I put the Aggregate Sum in that calculation?

Thanks,
Ezequiel

[Daniel]

Hello Ezequiel,

When using Ajax binding you should use ClientFooterTemplate instead of Template since the aggregate will not be available on the server. To subtract a value passed to the view, you could use the following approach:

ClientFooterTemplate("Total: <#= $.telerik.formatString('{0:c}',Sum - " + Model.TotalCost + ")#>")

Regards,
Daniel
the Telerik team

[Ezequiel]

Thanks, that worked fine.

And what about if the Grid is BatchEditing, how can I update the total before submitting the changes?

thanks again.

Ezequiel

[Daniel]

Hello again Ezequiel,

I am afraid that this is not supported. The data needs to saved and the Grid to be rebound in order to show the updated total.

Regards,
Daniel
the Telerik team