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, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
