Netted DC Demand Quantity

Type

Derived

Description

Net the scheduled receipts and loaded-dc inventory.

Measure Formula

"Netted DC Demand Quantity" = if (!isPast(), if ("DC Demand Plan Quantity" > ("DC Inventory" + "Scheduled Receipts"), "DC Demand Plan Quantity" - "DC Inventory" - "Scheduled Receipts", null), null)

Dimension Summarizations

DimensionRollupRolldown
DistributionCentersSumNone
ManufacturingSumNone
PlantsSumCustom
ProductSumNone
TransportModesSumNone