Skip to Content
0
Former Member
Jul 09, 2015 at 05:43 AM

Delivary Calculations At Bex Query Level

13 Views

Hi ,

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.

Regards,

Venkat