Numberformat in Footer

Suite and Optimus Suite 5
#1

Hi,

How to Number format in the footer.

Kindly help us with the sample

Thank you,
Arun

#2

If the column type supports the number format it also will be applied for the footer.

#3

Hi,

But It is not displaying the number format in the footer. In the Grid it is showing the Number format correctly but in the footer it is showing whole number without 1000 separated.

I have attached the screen shot of the grid. Please advice

footer_number_format_problem.jpg504×521 25.8 KB

#4

Please, clarify if you are putting the exact number in your footer or use the stat counters?
number format will be applied only to a stat counters in your footer.
for example:
myGrid.attachFooter("#stat_total");

#5

Hi,
I am using Function to sum the column.
function sumColumn(ind)
{
var out = 0;

for(var i=0;i<BillSummaryGrid.getRowsNum();i++)
{
	out += parseFloat(BillSummaryGrid.cells2(i,ind).getValue());
}

return out;

}

i am trying to more footer to have different column total.

Thank you,

#6

so, you are using the solution from the following sample:
dhtmlx.com/docs/products/dhtmlxG … ooter.html

according to its code calculateFooterValues() function simply sets the innerHTML text for the cell of the footer to a new calculated one. This text won’t be converted according to the number format. You will have to format it manually.