Forum Discussion
TanLC
1 year agoFrequent Visitor
Calculation of Order Qty based on Minimum Level
Hi, in below table, I would like to calculate Order Status, Daily Balance (inc. Ordered Qty) (kg) and Stock Day(s) (with Ordered Qty). Note: Stock Day(s) should always above Standard Safety Stock Da...
Irwan
Super User
1 year agohello TanLC
i see, so what condition when the addition becomes double/triple?
in 4/4/25, the value will add Standar Order Qty once (6974.43+3000=9974.43).
But in 14/4/25, it will add Standar Order Qty twice (4957.45+2x3000=10957.45).
then in 29/4/25, it will add Standar Order Qty three times (1931.99+3x3000=10931.95).
Thank you.