1 2 3
| SELECT Month([DateExpedition]) AS Mois, Year([DateExpedition]) AS Annee, Sum([KPI OTIF - KHELIL].CommandeOrbit) AS Total_Commandes_Orbit, Sum([KPI OTIF - KHELIL].CommandeTMS) AS Total_Commandes_TMS, Sum([KPI OTIF - KHELIL].OTIF_InTime) AS Total_Commandes_livrees_dans_delais, ([Total_Commandes_TMS]/[Total_Commandes_Orbit])*100 AS OTIF_IF, ([Total_Commandes_livrees_dans_delais]/[Total_Commandes_Orbit])*100 AS OTIF_IT, IIf([OTIF_IF]>=100,"100",Round([OTIF_IF],0)) AS OTIF_InFull, IIf([OTIF_IT]>=100,"100",Round([OTIF_IT],0)) AS OTIF_InTime, (([OTIF_InTime]+[OTIF_InFull])/2) AS OTIF
FROM [KPI OTIF - KHELIL]
GROUP BY Month([DateExpedition]), Year([DateExpedition]); |
Partager