Could you please let me know how I can acheive below calculations at Bex Query Level.
1. No of Deliveries on Time : ( IF time between GI and GR is Equal to the Lead time)
2. No of Deliveries in Time : (IF time between GI and GR is Less Than Lead Time)
3. No of Deliveries Not In Time : ( IF time between GI and GR is Greater Than Lead Time)
4. Standard Deviation : ( Measure of Variability in the Lead times . Higher it is higher is the range of values in Lead time.)
Please note : I have GI, GI and Lead time are available at Multiprovider Level.