Sorting #s or Dates problem

[CCMKEENER]

I Can not get BO to sort corectly. The app is sorting, for example: 1,10,11,12,13...

When in reality, it should sort:1,2,3...

Any ideas. Thank you for your help, Chris

 

[binboy77]

Is there any Section breaks in the report? In that case, you need to specify the contexts for the sort to apply correctly.
Also check if the field on which sort is applied is a numeric field or a character field.

Bin

 

[skrandel]

Clearly your fields are character strings.

Build a variable that converts them to numbers using ToNumber function and then use that new variable to sort on.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[skrandel]

If you are going to tell me that your field is a numeric field in the database, then the problem is that the field is defined as character in the universe.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com