Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
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
Thanks
May be this
If(Len(Trim([Actual GI Date])) = 0, 'UNDELIVERED LATE',
If([Requested date] < [Actual GI Date], 'EARLY',
If([Requested date] = [Actual GI Date], 'On Time',
If([Requested date] > [Actual GI Date], 'LATE')))) as Performance,
IF(LEN([Actual GI Date])=0,'Undelivered late') AS Performance
May be this
If(Len(Trim([Actual GI Date])) = 0, 'UNDELIVERED LATE',
If([Requested date] < [Actual GI Date], 'EARLY',
If([Requested date] = [Actual GI Date], 'On Time',
If([Requested date] > [Actual GI Date], 'LATE')))) as Performance,
Thank you Sunny!
This has worked.