I want to divide one aggregate by another.
Take these aggregates
Aggregates(Sub(aggregates)
aggregates.Add(Function(p) p.Total).Min().Max.Count()
aggregates.Add(Function(p) p.Total).Average()
aggregates.Add(Function(p) p.Total).Sum()
aggregates.Add(Function(p) p.Enrolments).Average()
aggregates.Add(Function(p) p.Enrolments).Sum()
aggregates.Add(Function(p) p.StudentEvents).Average()
aggregates.Add(Function(p) p.StudentEvents).Sum()
aggregates.Add(Function(p) p.Products).Average()
aggregates.Add(Function(p) p.Products).Sum()
aggregates.Add(Function(p) p.Male).Sum()
aggregates.Add(Function(p) p.Female).Sum()
aggregates.Add(Function(p) p.Students).Sum()
End Sub).
I want to do something like this below, note "sum / Students " where sum is the sum of enrolments and students is the sum of students, is this possible? thanks
columns.Bound(Function(p) p.Enrolments).Format("{0:C}").
ClientFooterTemplate("Avg #= kendo.toString(sum / Students ,'C')#<
br
/>Total #= kendo.toString(sum ,'C')#").
ClientGroupFooterTemplate("<
div
>Avg #= kendo.toString(sum / Students ,'C')#</
div
><
div
>Total #= kendo.toString(sum ,'C')#</
div
>")