Dear Experts, I would like to calculate the percentage of stock out days that were longer than 5 working days.
I have a table with the information of SafetyStock and a table with the daily stock-level. Any ideas? Thank you!
Page 1 / 1
You can count the amount of days where you had a stockout like:
(SUM(CASE WHEN STOCK_LEVEL < SAFETY STOCK
THEN 1
ELSE 0
END)) / COUNT(Round_day)
and put it as a single KPI.
I hope this helps.
Hello Nihat, thank you for the hint, this would work
However. Stockout only counts if STOCK_LEVEL < SAFETY STOCK = 0 FIVE DAYS in a ROW that's my challenge
Kindest
Hello Nihat, thank you for the hint, this would work
However. Stockout only counts if STOCK_LEVEL < SAFETY STOCK = 0 FIVE DAYS in a ROW that's my challenge
Kindest
Maybe you can use the LEAD-Function in combination with use case when STOCK_LEVEL < SAFETY_STOCK and sum up until you don't have stock out anymore. When it's 5 you can set it as '1' and if isn't 5 you can set it to 0. In the end you can calculate the average of all (stockouts_longer_than_5) / (stockout_total)
That would be my approach.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.