Purpose
This measure supports price integrity monitoring and leakage detection by tracking the erosion between a reference price (such as the list price) and the realized transaction price.
Business Context
Price Realization compares the weighted realized selling price against the weighted reference (list) price. It helps business users understand how effectively list prices are being realized in actual transactions and identify the impact of discounts, negotiations, and commercial conditions on pricing performance.
Definition
The measure calculates the weighted realized price divided by the weighted list price over the Agent’s filtered scope.
Business Formula
Price Realization (%) = (Sum of Unit Invoice Price × Quantity) / (Sum of Unit List Price × Quantity)
Agent Expression
SUM(Revenue) / NULLIF(SUM(UnitListPrice * Quantity), 0)