Derived
"Ending Inventory" = if (not isNull("DC Inventory"), "DC Inventory", max(null, "Beginning Inventory" - "DC Demand Plan Quantity" + "Scheduled Receipts" + "Proposed Receipts"))
| Dimension | Rollup | Rolldown |
|---|---|---|
| DistributionCenters | Sum | None |
| Manufacturing | Last | None |
| Plants | Sum | None |
| Product | Sum | None |
| TransportModes | Sum | None |