Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I get the following below when used Match
=Match(Inv_Criticality,'A','B','C','O')
Thank you,
Kind regards
Nayan
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
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))))
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
Thank you Marco. It worked.
Kind regards
Nayan