1st photo is expected result after adding formulas, 2nd photo is my result. Where am I going wrong?
formulas used -
Beginning Inventory - IF 'SYS01 Time Settings By Week'.'Not 1st Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory Forecast Demand - 'DEM03 Demand Forecast'.Final Forecast
Reorder Flag - OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0
Suggested order amount for month - MONTHVALUE(Forecast Demand)
PO Submitted - IF Submit Purchase Order Request? THEN 1 ELSE 0
Confirmed PO Delivery - OFFSET(PO Submitted, -Shipping Time Weeks, 0)
Shipping Method - 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Supplied By]
Shipping Time Weeks - 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: Shipping Method, LOOKUP: 'SYS08 SKU Details'.Product]
Confirmed Purchase Order Receipt - IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0) ELSE 0
Ending Inventory - Beginning Inventory + Confirmed Purchase Order Receipt - Forecast Demand
Safety Stock Target - HALFYEARVALUE('DAT04 Distribution Center Parameters'.Weekly Safety Stock)
Safety Stock Exception Count - IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0
@spacebar clicker As you click to unlock rewards, you'll find yourself involuntarily dragged into the game.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
