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 |