We have had an on-going issue with trying to sort records in both Views and Reports.

Specifically, we have a field we call "Probability". The field is set up as a pick list with values of 0, 25, 50, 75 100. We use it in the Potentials Module to rank the probability of closing a potential and getting the order. When we try to sort the data in a view by that column it will place the records that have the 100 value between the records with 0 and 25 values. It does this whether you sort in ascending or descending order.

The same problem occurs when we create a report and group data by that field.

We would like to see the data sort in numerical order and not place the 100 value between the 0 and 25.