I have created a table from a large dataset. Several of the data columns contain numeric data with a minimum value of -4.00 and a positive but small maximum. When I try to sort (PLB985_Undiff for example) in ascending order, the result is all zeros for all data columns. Sorting by descending values in the same column produces zeros in that column and various other numbers in the rest of the columns. Clearly, the sorting is not working for these data columns. I have no problems sorting by entry (integer, auto increment) or GeneID. Thank you for your help.
I have created a table from a large dataset. Several of the data columns contain numeric data with a minimum value of -4.00 and a positive but small maximum. When I try to sort (PLB985_Undiff for example) in ascending order, the result is all zeros for all data columns. Sorting by descending values in the same column produces zeros in that column and various other numbers in the rest of the columns. Clearly, the sorting is not working for these data columns. I have no problems sorting by entry (integer, auto increment) or GeneID. Thank you for your help.
Hi blgregg,
Thank you for your purchase.
Column PLB985_Undiff is working fine for me. Did you select Column Type to Float?