Excess-Stock Value [Inventory]

KPI Excess-Stock Value

Description Value of Stock surplus (i.e. above Target Max)

Calculation Sum of (last period only)IF [Quantity in Stock] > [Target Stock Max] THEN ([Quantity in Stock]-[Target Stock Max])*[Unit Value] ELSE 0 END

KPI Colororange_10_0

Variance Colororange_blue_diverging_10_0

Format Currency

Positive Values #,##0

Negative Values (#,##0)

Other Packs