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.
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
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…
