List Box Sort

[Anonymous]

Hi

In have the following expression in a list box

=if(Inv_Criticality = 'A', 'Critical',

  if(Inv_Criticality = 'B', 'Semi Critical',

  if(Inv_Criticality = 'C', 'Non Critical',

  'Others')))

However, I am struggling to sort in the following order which is

• Critical , Semi-Critical, Non Critical and Others.

I get the following below when used Match  

=Match(Inv_Criticality,'A','B','C','O')

Thank you,

Kind regards

Nayan

[Anil_Babu_Samineni]

Try to add your expression as

=if(Inv_Criticality = 'A', dual('Critical', 1)

  if(Inv_Criticality = 'B', dual('Semi Critical',2),

  if(Inv_Criticality = 'C', dual('Non Critical',3),

Dual( 'Others',4))))

[MarcoWedel · Accepted solution]

Hi,

maybe one solution might be to change your sorting expression to:

=Match(Inv_Criticality,'C','B','A')

and sort in descending order.

hope this helps

regards

Marco

[Anonymous]

Thank you Marco.  It worked.

Kind regards

Nayan