Start Building Professional
Web Apps Today

stat_total on comma seperated values of a column

I have a column data with comma seperated values,However when I perform a stat_total the addition is not able to consider the comma value as a formatting type rather is treating it as a delimiter and restricting the summation only till the comma in every cell.


How do I tell the grid to identify the comma as a formatter and not as a delimiter and still use the #stat_total to perform addition?

In the JavsScript delimiter between fractional and integer is dot. If you want grid to count fractional number correctly you should pass to in number with dot. But you can set number format for the cell which you want to be with comma delimiter. 
mygrid. setColTypes(“ron”,”end”)//cell which you want set formatting should have “ron” or “end” type
mygrid.setNumberFormat("0,000.00",0,",",".")//second parameter - index of a cell