Web Report Sort by Numeric Values
Summary:
I have a web report in which I am pulling order_dtl.cust_short_text_1 field and attempting to sort by the numeric value. The issue I am having is that it sorts by the numeric value of the first character versus the value. In the below snippet, you can see that 19 is coming before 2 because "1" is before "2" in the first character position.
What options do I have for updating to the desired sort in which 2 comes before 19?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
25B.08m
Code Snippet (add any code snippets that support your topic, if applicable):