What is the syntax to add set analysis to the below statement? I do not want the lookup feature to operate if [Delivery No.] = 'Result' . I'm not sure how to incorporate that into the syntax.
date#(WeekEnd(Lookup('Delivery_Date', 'Delivery_ID', [Delivery No.], 'Delivery_Date'), 0,2),'MM/DD/YYYY') as 'ActionDate'
Thank you for the help!