Proposed Receipts

Type

Derived

Description

Measure Formula

"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 Summarizations

DimensionRollupRolldown
ManufacturingSumNone
PlantsSumNone
ProductSumNone