Start Building Professional
Web Apps Today

Price column formating

Hi Team,

I am using price column in grid.I want to format the value of column as $12,300.00
And also I am using mygrid.setColSorting("int") and filter as #numeric_filter.
The sorting and filtering should work in this case.

Thanks,
-Agile

You need to set column as "edn" instead of "price" and use 
     grid.setNumberFormat("$0,000.00",0)

In such case you can provide raw numbers in origianal dataset - they will be correctly formated and still be available for int-like sorting|filtering.