Derived
"Shortage" = if ("Plant Demand Plan Quantity" > ("Beginning Inventory" + "Scheduled Receipts" + "Proposed Receipts"), "Plant Demand Plan Quantity" - "Beginning Inventory" - "Scheduled Receipts" - "Proposed Receipts", null)
Dimension | Rollup | Rolldown |
---|---|---|
Manufacturing | Last | None |
Plants | Sum | None |
Product | Sum | None |