Description: This solution discusses why some numerical fields do not sort by the whole number
When sorting Prospect Ratings columns in List Management it can appear that the values are not sorting properly.
The sorting is due to how Raiser’s Edge stores Blackbaud Ratings. Though the values appear to be currency values, they’re being stored as text values by Raiser’s Edge. This means that sorting by ascending/descending is essentially alphabetizing the results rather than sorting by the practical dollar amount.
Refer to the ImportOmatic User Guide for additional information.