Proposed Receipts

Type

Derived

Description

If within transportDetails.lead_time, 0, else “Proposed Receipts from Plant” * TransportDetails.modepercent

Measure Formula

"Proposed Receipts" = if (!isPast ("Proposed Receipts from Plant"[ lag(Manufacturing, "Lead Time Value")]), lookup("Transport_Details_RS", memberName(member("Plants")), memberName(member("DistributionCenters")), memberName(member("TransportModes")), "MODE_PERCENT") * "Proposed Receipts from Plant", 0)

Dimension Summarizations

Dimension	Rollup	Rolldown
DistributionCenters	Sum	None
Manufacturing	Sum	None
Plants	Sum	None
Product	Sum	None
TransportModes	Sum	None