Sorting dollar values in a grid field

is it mapped to a decimal or text field ?

@xingc try checking, whether did you use field parameter for grid text column or not. By the way what problem are you facing

If you are have a sorting problem in the grid,may be it's because you did not defined sort in the paging info, by default if not defined it will return unsorted result try the below code in your sail.
a!pagingInfo( startIndex: 1, batchSize: 6, sort: a!sortInfo( field: "cost_decmal", ascending: true or false ) )

@xingc,
Once the data is retrieved, the respective field is decimal and you displaying it after formatting.
If I understand it correctly, in grid configure the field with the respective field that is mapped to database column.And the display value (formatted text) map to value.

@sathya Srinvasan, it turns out that I need to map it to a decimal field in the cdt. Thanks.