Sum percentage

[vivianteoh]

May I know is there a way to sum percentage correctly?
See sample below:

I have a formula (column B / column A) * 100%. If the result column is summed, the result is shown as 113.06 but what I want is (total of column B / total of column A) * 100% = 0.77.
May I know is there a way to do so?

[paramvir]

It can be done by writing a column.render callback for affected column and override the cell value in summary row.

Code: [Select]

column.render = function(ui){
 var rd = ui.rowData;
 if(summary row ){
   return rd.B/rd.A * 100
 }
}


[vivianteoh]

Thanks. Will try this out.