Hi,

You could do this in a couple of ways. It depends on the column's DataType. If the column is an object or a string, you could do this using your formula. You could use the IsError function, for example, to have the formula return a string instead the error message.

Another way to do it would be to use a CreationFilter and change the text of the UIElement in the cell.

Another way would be to hide the formula result column and put a new, unbound column in it's place. Then you could use the InitializeRow event to read the real value and translate it into any text you want and set the value of the unbound column.

Forget this... just figured it out..

Just tell me how can I set custom strings for Nan, #NUM, etc...

I found the problem:

Summary is not calculating Median for all rows and rows where COL B between 0 and 100.

Average is calculating correctly. 

Any bugs on median formula???

I'm also having another problem:

When my grid shows up it haves approx. 30000 rows. The summaries are not being calculated correctly. Only when filter the grid, they are shown correctly. if I take filters off again, it works OK so only after first load and if no filter is applied the values are not showing up.

Any ideas??? Its urgent...