Derived
Net the scheduled receipts and loaded-dc inventory.
"Netted DC Demand Quantity" = if (!isPast(), if ("DC Demand Plan Quantity" > ("DC Inventory" + "Scheduled Receipts"), "DC Demand Plan Quantity" - "DC Inventory" - "Scheduled Receipts", null), null)
| Dimension | Rollup | Rolldown |
|---|---|---|
| DistributionCenters | Sum | None |
| Manufacturing | Sum | None |
| Plants | Sum | Custom |
| Product | Sum | None |
| TransportModes | Sum | None |