Revenue Forecast Accuracy

Type

Derived

Description

Measure Formula

"Revenue Forecast Accuracy %" = if(isPast() and !isNull("Shipped Sales Orders Revenue") and ("Shipped Sales Orders Revenue" <> 0), ("Demand Plan Revenue" - "Shipped Sales Orders Revenue") / "Shipped Sales Orders Revenue")

Dimension Summarizations

DimensionRollupRolldown
CustomersNoneNone
FiscalNoneNone
GeographyNoneNone
ProductNoneNone