Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try implementing Marcus solution in backend for better performance.