This page provides summary of the Formula Expressions used in the Price Realization Agent (Reference).
Current Price
Definition
The weighted average unit price over the selected period, computed as total Invoice Price divided by total Quantity. Reflects the average realized selling price per unit.
Formula
SUM(InvoicePrice)/SUM(Quantity)
Current List Price
Definition
The weighted average unit price over the selected period, computed from the sum of local list prices divided by the sum of quantities. Reflects the average realized list-price level per unit.
Formula
SUM(LocalListPrice)/SUM(Quantity)
Price Realization Rate
Definition
The ratio of the realized customer price to the corresponding list price for the same region, indicating how closely transactions align to list (1.0 = at list; < 1 = discounting; > 1 = premium).
Formula
s1.CurrentPrice/nullif(s2.CurrentListPrice,0)
Recommended Price
Definition
A target price set halfway between the current price and the regional list price, rounded to two decimal places to reflect currency precision.
Formula
round(s1.CurrentPrice + ((s2.CurrentListPrice - s1.CurrentPrice) * 0.5),2)
Revenue Uplift
Definition
The incremental revenue at current volume from moving to the Recommended Price, calculated as recommended price times quantity minus current total revenue.
Formula
((s1.CurrentPrice + ((s2.CurrentListPrice - s1.CurrentPrice) * 0.5)) * s1.Quantity) - s1.TotalRevenue
Revenue Uplift (pp)
Definition
The percentage change in revenue relative to current revenue from moving to the Recommended Price at current volume, expressed as percent points.
Formula
(((s1.CurrentPrice + ((s2.CurrentListPrice - s1.CurrentPrice) * 0.5)) * s1.Quantity) / NULLIF(s1.TotalRevenue,0)-1)*100