Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need help in sorting the values in list box alphabetically.
But the problem is , we have NA and N/V in our data and we need to keep these two specific values at very last and not in between the data in list box.
Is there any way to get this type of custom sort.
Please help me.
Hi,
Go to Properties -> Sort Tab -> Write the expression for sorting as below.
If(Fieldname = 'NA' or Fieldname = 'N/V',1,2)
And then keep the sorting as ascending.
Also select the Text sorting.
Regards,
Kaushik Solanki
Hi,
Go to Properties -> Sort Tab -> Write the expression for sorting as below.
If(Fieldname = 'NA' or Fieldname = 'N/V',1,2)
And then keep the sorting as ascending.
Also select the Text sorting.
Regards,
Kaushik Solanki
-wildmatch(dim1, 'NA', 'N/V', '*')
replace dim1 with your field
try in sort tab expression
=match(fieldname.'Value1','value2')
Hi, Thanks for the help. I tried both the answers and both are working fine.
Thanks for your help.