I want to flag serial numbers that have both Installation and Installation Completed activities and with order status Closed or Closed Complete. If a serial number have both then it means the serial number has installation completed True.
7 réponses
The below will match on multiple conditions within a serial number. See if this matches on what you're trying to do?
{FIXED [SERIAL_NUMBER], [ORDER STATUS], [ACTIVITY] : (IF MAX([ORDER STATUS])='Closed' AND MAX([ORDER STATUS])='Closed Complete'
OR MAX([ACTIVITY])='Installation' OR MAX([ACTIVITY])='Installation Completed' THEN TRUE END) }
Best, Don Wise -
Please don’t forget to upvote and/or Select as Best by clicking the hyperlink below in the response that answered your question.
