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