Delivary Calculations At Bex Query Level

[Former Member]

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

[former_member186399 · Accepted solution]

Helo Venkat

Use formula variable to find the difference between the GI & GR and then compare it with lead time days

Regards

Gajesh

[Former Member]

Hi,

Write the conditions in Query on time fields, Max you will reach the requirement.

Thanks & Regards,

Srinu.Rapolu