Shortage

Type

Derived

Description

Measure Formula

"Shortage" = if ("Plant Demand Plan Quantity" > ("Beginning Inventory" + "Scheduled Receipts" + "Proposed Receipts"), "Plant Demand Plan Quantity" - "Beginning Inventory" - "Scheduled Receipts" - "Proposed Receipts", null)

Dimension Summarizations

DimensionRollupRolldown
ManufacturingLastNone
PlantsSumNone
ProductSumNone