What if we specified a special group_operator to compute the average price column of this analysis view?
Imagine we use a column that gives the total price for the line (i.e. qt * unit_price), and we specify a group_operator along these lines (keeping in mind that OpenERP will add the braces after the operator): group_operator="(1.0/sum(product_qty))*sum"
This way when the grouping is done it should execute this:
SELECT (1.0/sum(product_qty))*sum(total_price) FROM ...
What if we specified a special group_operator to compute the average price column of this analysis view?
Imagine we use a column that gives the total price for the line (i.e. qt * unit_price), and we specify a group_operator along these lines (keeping in mind that OpenERP will add the braces after the operator): group_operator= "(1.0/sum( product_ qty))*sum"
This way when the grouping is done it should execute this: product_ qty))*sum( total_price) FROM ...
SELECT (1.0/sum(
Would it work?