Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I notice on the forums that there are plenty of Delivery tables for supplier performance, but i am trying to evaluate my own companies delivery performance to our customers... does anyone know of any good ones i can use as a template? presumably i would have to use IF statements like greater than 2 days = late etc?
Aah I see it now...
If(DelPerf>=0, 'OnTime',
If(DelPerf >=1, 'Late',
If(DelPerf <=1, 'Early'))) AS DelPerf2
brilliant, that worked! looks like i have the script now to design a graph etc - thanks everyone, especially you Marcus. Have a great Wkend