Is there a setting somewhere which changes the sort definition in the data assignment settings?  My issue is that I have categories that I want to sort by, the field name is 'Aging category' and the content of this field is, for example:

90

120

183

270

365

5000

Despite having numbers as content the field is defined as text so that I can group on them (count number of applicable records)

My output sorts as follows:

120,183, 270, 365, 5000, 90

Image is attached.

Any suggestions will be appreciated

thanks

donald

 

 or register to reply.

Notify Moderator