How do you create a Calculated Footer

[Wyatt]

for KendoGrid I want to make a calculated footer.  Take the total of column A and the total of column B and divide them.

[Alex Gyoshev]

Hello Wyatt,

You can achieve this through the DataSource aggregates and a column footer template. See the grid aggregates demo and this jsBin showing how to access data across columns.

All the best,
Alex Gyoshev
the Telerik team

[Joe]

How would you then take your calculated footer template example and apply #=kendo.toString(sum,'P2')# equivalent?
Thanks.

[Alfredo]

How would you handle a case where the Denominator in the calculation is 0 (thus divide by zero).  In my grid, where I format as Currency, it displays 'INFINITY'

[Joe]

I've answered my own question. The solution for my calculated cross columns was:
.ClientFooterTemplate("<div>Avg: #= kendo.toString(data.TotalMarginAmt.sum / data.TotalSalesAmt.sum,'P2') # </div>")

[Alex Gyoshev]

Hello Alfredo,

You can have conditional expressions in templates, so you can handle this separately:

    # if (isZero) { #
       N/A
    # } else { #
       formatted value
    # } #

 

Regards,
Alex Gyoshev
Telerik

 

 

[Alfredo]

Alex,

Thanks for your reponse.  What I ended up doing was using a function in the template to check for zero.  I will try your solution next time I run into this situation.

Alfredo