I have a mvc grid with as model { int projectnumber, int Monday }
and code
columns.Bound(c => c.Monday).Title(text: "Monday").ClientFooterTemplate(template: "#=sum#");
.DataSource(datasource => datasource
.Ajax()
.Aggregates(aggregates =>
{
aggregates.Add(a => a.Monday).Sum();
})
Now I only want to create the sum over all lines in the grid with exception of the line with project number 1.
The AJAX read gets back [1,1] and [2,4] and [3,5] So I hope to get a sum of 4+5=9 instead of the 10 I get with a normal sum.
I hope myu question is clear and somebody knows how to do a partial sum.
With kind regards,
Maurice Lucas