Weighted average of a column in the group by on kendo grid.

[Kevin]

I have columns a and column b in our grid,   and instead of average of b, I want SUM(A*B)/Sum(B) to show up in the group by aggregate to give me the weigthed average.

Is there a way to do this with Kendo UI Grid.  Please give an example if you have done this before.

Thanks

[Alexander Valchev]

Hi Kevin,

I am afraid that what you would like to achieve is not supported out of the box. As a workaround you can define a custom function that performs the calculation in the groupFooterTemplate. As an example:

{ field: "A", title: "A", groupFooterTemplate: "#= calculateResult() #" }

To get the field values I recommend using the current state of the grouped DataSource that can be retrieved with the view method.

Regards,
Alexander Valchev
the Telerik team