Shortage

Type

Derived

Description

If Loaded Ending Inventory exists, then that, else Ending Inventory[Previous] - DC Demand Plan Quantity + Scheduled Receipts + Proposed Receipts - maxed. to zero

Measure Formula

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

Dimension Summarizations