Descending order mixed up in column

HCL Domino Domino Forum
1

I have a simple column sorting a text field value (contains numbers and dashes) in descending order, however the order is messed up. For example the column displays 2006-101 as being larger than 2006-1003. Anyone know how to resolve this?

2006-202

2006-201

2006-200

2006-103

2006-102

2006-101

2006-1003

2006-1002

2006-1001

2006-1000

2006-100

2006-079

Many thanks,

Ralph

2

Subject: Descending order mixed up in column

Hi,

Add a Hidden column just before the mentioned column with the following formula and sort this column instead of the one already…

temp := @Explode(fieldname;“-”);

@ToNumber(temp)

Regards

Rajiv

3

Subject: RE: Descending order mixed up in column

Thanks a lot Rajiv, works like a charm!

Kind Regards,

Ralph