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 |