If Or

[Anonymous]

Hi Experts 🙂

I have a question regarding IF(OR syntaks with several parameters:

If (PurchaseOrderHeader_StatusWms) is Closed, or Locked or Received than I need to return Arrived, 

If (PurchaseOrderHeader_StatusWms) is Sent, I need to return Planned

If (PurchaseOrderHeader_StatusWms) is None, I need to return Not Planned

I hope you can help me.

Thank you

[marcus_sommer]

It would be possible to create a nested if-loop including your OR's but better would be to use:

pick(match(PurchaseOrderHeader_StatusWms,
    'Closed', 'Locked', 'Received', 'Sent', 'None'),
    'Arrived', 'Arrived', 'Arrived', 'Planned', 'Not Planned')

- Marcus

[Anonymous · Accepted solution]

Many thanks Marcus. It works perfectly 🙂 🙂
You made my day ....

[passionate]

Try implementing Marcus solution in backend for better performance.