Sort Order

[smilingjohn]

Hi All, 

I am using the below expression in sorting the values , but when certain sections are made the values changes its order, 

How do i keep this sorting fixed . 

=if(UAP_Release_ID='18.1',1 ,if(UAP_Release_ID='18.2',2,if(UAP_Release_ID='18.3',3,if(UAP_Release_ID='18.4',4,if(UAP_Release_ID='18.5',5,if(UAP_Release_ID='18.6',6,
if(UAP_Release_ID='18.7',7,if(UAP_Release_ID='18.8',8,if(UAP_Release_ID='18.9',9,if(UAP_Release_ID='18.10',10,if(UAP_Release_ID='18.11',11,if(UAP_Release_ID='18.12',12,
if(UAP_Release_ID='18.01',13,if(UAP_Release_ID='18.02',14,if(UAP_Release_ID='18.03',15,if(UAP_Release_ID='18.04',16,if(UAP_Release_ID='18.05',17,if(UAP_Release_ID='18.06',18,
if(UAP_Release_ID='18.07',19,if(UAP_Release_ID='18.08',20,if(UAP_Release_ID='18.09',21,if(UAP_Release_ID='18.010',22,if(UAP_Release_ID='18.011',23,if(UAP_Release_ID='18.012',24
))))))))))))))))))))))))

[Gysbert_Wassenaar]

try somehting like this instead: match(only({1}UAP_Release_ID), '18.1','18.2', ...etc... ,'18.012'))