Bug Tracker Incident #8321
The "Ave Price" column in the "Summarized Sales By Customer By Item" report uses the aggregate AVG() function.
AVE(baseunitprice) = 5.00 <- Incorrect Average Price
+ "CASE WHEN SUM(cohist_qtyshipped) = 0"
Change Summarized Sales by Customer Type, Summarized Sales by Customer Type by Item, and Summarized Sales by Customer by Item and add a new column to listview - Weighted Average Price. Calculate Wt. Avg Price as described by requestor - SUM(baseextprice) / SUM(cohist_qtyshipped).
This calculation is used in other places:
|Project||XTUPLEAPPS||Ported From Mantis||x|
SubscribersYou do not have permission to view subscribers.
|12/16/10 09:13||acdrupal||New||Incident Added|