Excess Transportation Costs

Cube

Transportation

Description

Projected transportation costs exceeds budget

Type

Regular (Batch and Interactive)

Priority

Medium

Measure

Transportation Cost

Owner

admin

Due Date

+10 days

Formula

Excess_Transportation_Costs."Transportation Cost"[level("Product Family")][level(Plants.Summary)][level(DistributionCenters.Summary)][level(TransportModes.Summary)] assert !(!isPast() and !isNull("Budget Transportation Cost") and ("Transportation Cost" > "Budget Transportation Cost") )