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 |