I have entered the following script which gives me the performance I need for Early, On time, and late deliveries, however I now need a line of script that says if there is no 'Actual GI Date' performance should list 'Undelivered late', any ideas?
If([Requested date] < [Actual GI Date], 'EARLY',
If([Requested date] < [Actual GI Date], 'On Time',
If([Requested date] > [Actual GI Date], 'LATE'))) as Performance,
Can anyone help? I am assuming it is something along the lines of:
If ([Actual GI Date] = 'BLANK', 'UNDELIVERED LATE') as Performance