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 |