Product: List Management

Description: This solution discusses why some numerical fields do not sort by the whole number

Environment: All

Versions: All

Answer: 


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.