Grid Footer Average

Hi Radzen Dev Team,
Do you have any working samples for getting the datagrid footer calculations such as column averages?

Can this be programmed only using the client side datagrid events, without having to load data against the backend? I mean, traverse the grid data and do the calculations from the client, after editing any of the datagrid cells?

Thanks for the great help
Regards

Hi @Jose_Carrillo,

You can check the Footer Template section from our documentation.

You can calculate the average like this:

The Value of the average property is:

${getOrderDetailsResult.map(i => i.Quantity).reduce((x, y) => x + y) } / ${getOrderDetailsResult.length}

And then use it in the DataGrid:

Thanks Atanas , It worked!