Definition
Price is the average realized unit selling price (average invoice price) over the selected transactions. It is computed from Revenue and Quantity in the Aggregated Transactions structure.
Formula
Price = sum(Revenue) / sum(Quantity)
Example
Across all invoices for a product:
-
Total Revenue = 120,000
-
Total Quantity = 3,000 units
Price = 120,000 / 3,000 = 5