DataGrid 2 Widget Not Sorting Correctly When Has Empty Cells

I am using the Data Grid 2 module and everything is working correctly except the Sort functionality.  If all the cells in the column are populated with values everything works correctly, but if there is an empty cell in the column then the Sort does not work.  See screen shots below.  The Account Number column it is a straight text field.  I have verified that the values of the cells are empty not “”.  What can I do to make it sort correctly?      
0 answers