Performance calculation expression

[Anonymous]

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

[avkeep01]

IF(LEN([Actual GI Date])=0,'Undelivered late') AS Performance

[sunny_talwar · Accepted solution]

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,

[Anonymous]

Thank you Sunny!

This has worked.