Sorting incorrectly-Radiobutton field

HCL Domino Domino Forum
1

HiI have new field called Priority that is a radio button field. These are the values. All the old documents have “” value for this field.

1 - Low 2 3 4

5 6 7 8 9 10 - High

I am trying to sort this field descending .This is my column formula.

temp := @If(Priority=“”;“0”;

                   Priority= "10 - High";"10";

                   Priority ="1 - Low"; "1";Priority);

@ToNumber(temp)

But the view show up the fied value as

9

10

1

0

0

0

0

6

Any help would be appreciated. Thank you.

2

Subject: Sorting incorrectly-Radiobutton field

To debug this, try the following …

temp := @If(Priority=“”;“0”;

                   Priority= "10 - High";"10";

                   Priority ="1 - Low"; "1";Priority);

x := @ToNumber(temp);

@If(@IsError(x);“<”+temp+“>”;x)

If your Temp cannot be converted to a number, it will be shown with < > around it’s value.

3

Subject: RE: Sorting incorrectly-Radiobutton field

Thanks. I will try and see if the "temp field have any issues…

4

Subject: Sorting incorrectly-Radiobutton field

Did you sort the view column to “Ascending”. If you did that I am sure this would work

5

Subject: RE: Sorting incorrectly-Radiobutton field

Yes, I am sorting it Descending.

6

Subject: RE: Sorting incorrectly-Radiobutton field

is this the first sorted column in the view?