You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!