Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Delivary Calculations At Bex Query Level

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

replied

Helo Venkat

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

Regards

Gajesh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question