Derived
"Proposed Receipts" = if (! isPast( "Plant Demand Plan Quantity"[lag(Manufacturing, "Lead Time Value")]), if ("Plant Demand Plan Quantity" > ("Beginning Inventory" + "Scheduled Receipts"), "Plant Demand Plan Quantity" - "Beginning Inventory" - "Scheduled Receipts", null), 0)
| Dimension | Rollup | Rolldown |
|---|---|---|
| Manufacturing | Sum | None |
| Plants | Sum | None |
| Product | Sum | None |