E
Eliana Wolfeld
It would be tremendously useful to have in-stock rate available as actuals and constrained sales plan in AP reporting to help tell the higher-level story of why sales are being constrained.
We created an in-stock rate with our BI team for internal reporting that calculates at the daily level and aggregates to any time period. We have it set up as: [count of SKU in-stock] / 1.
  • Our count of SKU in-stock calculates to either 0 or 1 based on SKU inventory OH > [our internal min. inv.]; would be nice for Toolio's threshold to utilize the Good Weeks Min. Inv. value
  • The denominator is either 1 or 0 with 1 representing a single day if the style is in an eligible selling status - it fails to zero if outside of an active selling window for that style. It's wrapped in a case statement for it to fail to null if dividing by zero.