Hi,

I have an ultragrid that takes a datatable as datasource.

this datatable contains columns of type decimal (6 decimal places)

Is there a way of displaying custom decimal places and taking into consideration that the value will stay with 6 decimal places in order to have correct results when sorting and filtering

for example:

the table 1 is the original value.. i want to show it as table 2, but if sorting or filtering or conditional formatting  keep the average of ID 178 greater than the average of ID182

thx