Skip to Content
2
Former Member
Jun 28, 2007 at 10:00 PM

negative number in characteristic

1245 Views

Hi,

After some calculations I store a number, which can be negative or positive, in a characteristic. NUMC shows me a weird number when <0 and CHAR shows numbers like 1 -, 2, 3 -. These are correct, only the sign is located after the number.

I want to group the outcome in the columns of a report, but the result I get now has a sorting order of: 0, 1, 1 -, 2, 2 -, 3, 3 - etc.

I want it to be in a sorting order of - 2 , - 1, 0, 1, 2 etc. So the sign is in front.

I have been reading a lot for the last day, but never saw a solution. For instance I could not find a conversion routine, which does it.

Does somebody know how to handle negative numbers, so that the group sorting order is shown correct in the report?

Thank you,

Eelco