nested IF and wildmatch

[TomBond77]

Hi experts

I need to build 4 values for a system status: closed, open, deleted and '0'.

There might be a combination of "closed" and "deleted" as given by the screen below: "NOCO" is closed and "DLFL" is deleted.

My loading script doesn't work correct: any ideas how to solve it?

If(WildMatch([RSNOTIFIC__RXSYSTST], '*DLFL*'), 'Deleted', If(WildMatch([RSNOTIFIC__RXSYSTST], '*NOCO*'), 'Closed',
If(WildMatch([RSNOTIFIC__RXSYSTST], '*NOPR*', '*OSNO*'), 'Open', 0))) as [Notif. Status],

[Or · Accepted solution]

Coalesce(Pick(Wildmatch([RSNOTIFIC__RXSYSTST],'*DLFL*','*NOCO*','*NOPR*','*OSNO*'),'Deleted','Closed','Open','Open'),'0')

Note that the order in which the options are listed will determine which one is prioritized when more than one exists.