using sum in row cell

[Boschi]

Hi, I've got a grid containing a list of elements with a corresponding numeric value, where I use the aggregate functions to show the sum in the footer. Something like this:

ELEMENTS  |  VALUE

element1       |      1

element2       |      2

element3       |      3

---------------------------------

TOTAL           |      6

 

now I need to show beside the row number the percentual relative to the total, this way:

ELEMENTS  |  VALUE
element1       |      1 (16.67%)
element2       |      2 (33.33%)
element3       |      3 (50.00%)
---------------------------------
TOTAL           |      6

so I add to the VALUE column options this:

template: "#:value#<br>#=100*value/sum#%"

but the grid stops working, without even showing errors in the console. What am I missing?

[Georgi]

Hi Boschi,

Possible solution is to pass a function to the column.template property. Then access the aggregates using aggregates method and create the template:

• https://dojo.telerik.com/Etebo/3

Regards,
Georgi
Progress Telerik