how to sum of quantity in sale order line report

Question

I am creating report i need to calculate sum of all quantity in sale order line how to do that

Felipe · Answer

[[ reduce(lambda x, obj: x+obj.qty , list , 0 ) ]] : Total qty of list (try "objects" as list)

source: https://doc.openerp.com/v6.1/developer/05_reports/ [1]

o.order_line would be for the list of sale order lines

product_uom_qty is the qty field in sale order lines
so it would be

[[ reduce(lambda x, obj: x+obj.product_uom_qty, o.order_line, 0 ) ]]

[1] https://doc.openerp.com/v6.1/developer/05_reports/

Pinakin Nayi (pna) · Answer

Hi,

In this case you have create function field in report py file and in that just calculate # of qty. And for field use that function in rml file.