Hi,
I have number format with 1000 separator in the jsp page output xml.
I am trying to sum of the columns through custom sumcolumn function.
function sumColumn(ind)
{
var out = 0;
for(var i=0;i<BillSummaryGrid1.getRowsNum();i++)
{
out += parseFloat(BillSummaryGrid1.cells2(i,ind).getValue().replace(’,’,’’));
}
return out;
}
I am trying to replace commas in the thousands separator. it is replace only first commas. And Total is coming wrong
these thousands separator directly code in the jsp page
SUB TOTAL
18,268.1234
2,390,302.00
4,598.00
21,720.00
400.00
FOOTER TOTAL 47,376.12
You have any other method to replace the commas and correct total
Kindly help me with solution ASAP.
Thank you,
With Regards.
Arun