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.
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New β New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, noβ¦
Why in my model output is blank, after send explainability data.
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β¦
