Forum Discussion
GMadd
Helper I
Helper IDAX OTIF Formula to Included Scheduled Pickup
I have the formula below to help calculate my OTIF but I forgot to include any order (delivery) that has a pick up appointment. Some of our customers will schedule pick up appointment that is after t...
saurabhtd
Resolver II
Resolver IIGMadd updated version of your formula
Category =
SWITCH(
TRUE(),
OTIF[Credit]= "VERKBELEG", "Credit",
OTIF[Full]= "Short", "Late",
OTIF[Delivery Created Dat] > OTIF[Act. Gds Mvmnt Date], "Held for Material",
OTIF[Act. Gds Mvmnt Date] > OTIF[Dlv Plnd PGI dt], "Late",
NOT(ISBLANK(OTIF[Pickup Appt Date])) && OTIF[Pickup Appt Date] > OTIF[Dlv Plnd PGI dt], "On-Time",
"On-Time"
)
GMaddHelper I
Helper Ithank you for your response but I guess I was not 100% on what I need. In my screen shot below I want the first delivery 88004495 to show On-Time since the Pick up Appt Date was after the Dlv Plnd PGI dt. There was no other reason for this to be late as it was not delayed due to waiting for product. The next delivery is showing late as it should since it was shipped short.