Hi Daniel,

Thanks for your reply! Initially, I was converting the text to integer, however I just reverted it back to text and it still is sorting by the first integer. I've attached an image of the aggregate with the specific field highlighted. Although I should mention I'm using a data type mask forge component which takes a string of numbers and masks it as currency i.e. $96,000. So when displaying the data from the aggregate I also tried removing the dollar sign and commas via the expression below in an attempt to sort it correctly, but it is indeed saved as text in aggregate in the end.

Substr(Replace(GetProjectsByTeamMember.List.Current.DealSize, ",", ""), 1, Length(GetProjectsByTeamMember.List.Current.DealSize))

If you want to sort numeric make sure to sort on an attribute with numeric datatype. 

Can I sort on a text data type that's converted to integer via TextToInteger()? Or the attribute itself has to initially be numeric? Because that wasn't working either. 

Ok so for anyone else if it's not obvious, what Daniel mentioned is literally correct. The attribute itself has to be an integer, it doesn't matter if you convert the value to Integer. So I created a new attribute on my aggregate and for its value used the TextToInteger() function to convert the text attribute in question.

Thank you Daniel!

Yes, sorting is done in and by the database, so you need the right value inside the database. In a SQL query, you can do the conversion in the ORDER BY, but you cannot do that in the aggregate editor (it only allows you to select an attribute for sorting). So creating a calculated attribute and sorting on that is indeed the solution.