Odoo Help


How to sum a column in openoffice report?

on 5/16/13, 7:51 AM 8,491 views

I need to sum the amount_tax in a report just like it shows in the account_invoice tree view or sales_order view as a total in my invoice report, i don't want lines in my invoice. please help its seriously very urgent!

Can we write a function to add amount_total in sale_order report.py? anyone? please guide me in writing simplest way

on 5/23/13, 4:38 AM

Can anyone help !! Damn important.

on 6/21/13, 7:36 AM
On 7/16/13, 7:57 AM

[[ reduce(lambda x, obj: x+obj.amount_total , objects , 0 ) ]]

Tried this but no result, changed to this too [[ reduce(lambda x, invoice: x+invoice.amount_total , objects , 0 ) ]]

on 7/16/13, 8:29 AM

i use it for purchase order it work well

on 7/16/13, 11:55 PM

please try in invioce report for the amount total

on 7/17/13, 2:33 AM

more info https://doc.openerp.com/v6.1/developer/05_reports/

on 7/17/13, 2:59 AM

Francesco OpenCode

--Francesco OpenCode--

| 6 8 9
Grottaglie, Italy
--Francesco OpenCode--

Italian Odoo (OpenERP) Modules Developer LINKEDIN: http://www.linkedin.com/in/francescoapruzzese

Francesco OpenCode
On 5/16/13, 8:17 AM

Aeroo has got a funtion called sum_field that sum all the value for a field in yuor class.

This is an example that sum all amount_total in sale order

sum_field(o, 'amount_total')

This is a link to official documentation: http://www.alistek.com/wiki/index.php/Extra_Functions_-_sum

But I am using openoffice can it work???

on 5/16/13, 8:50 AM

Aeroo is based on OpenOffice!!

Francesco OpenCode
on 5/16/13, 11:20 AM

it didn't work with openoffice

on 5/22/13, 8:57 AM

what error you get?

Francesco OpenCode
on 5/22/13, 8:58 AM

i don't get an error but it doesn't print anything. I want to sum amount total of all the invoices in my report like it does in invoice tree in openerp. Please help

on 5/22/13, 9:04 AM

can you help in writing a function in report.py??

on 5/23/13, 4:36 AM

evon_dun: listen to me. The sum_field function work fine in openerp aeroo report. I use it everywhere and i haven't problem. If the function doesn't work you are doing something wrong. Post you code and we can halp you. If you search only help without explain what are you doing is impossible for use help you.

Francesco OpenCode
on 5/23/13, 11:15 AM

[[ sum_field(invoice,'amount_total') ]]

on 5/24/13, 1:58 AM

But you are using rml not aeroo report!!!

Francesco OpenCode
on 5/24/13, 5:16 AM

kindly guide me the complete way to add such a field either through programming or through openoffice. In openoffice either we add field from field builder or we can use rml.

on 5/24/13, 5:24 AM

My answer is in relation with aeroo reports. Rml is another report engine. Sorry but my answer is incorrect in your case.

Francesco OpenCode
on 5/24/13, 5:59 AM

France please show that this solution for Aeroo in the main answer and thx it helped me :)

on 6/3/13, 3:25 PM

No aeroo solution please

on 6/21/13, 7:38 AM


| 4 4 8
Ahmedabad, India

Odoo Expert

On 6/26/13, 7:50 AM

Hi evon,

Above suggested answer is right. It uses report_aeroo functionality if you want to achieve it with base_report_designer using sxw & report.py file then you need to follow below steps.

Define a global variable & do the calculation for sum in it in report.py file. Then at the end of the report in .sxw file call a function and return that global variable. This is how you can have sum amount in your report at the end. For more in detail you can refer Location Content report of Stock.

Here are some examples,

For version 6.0

For version 7.0

Hope this solve your problem.


Probably you are right but that example is too complicated, any other example?? However, i have been trying to install aeroo on my system for windows which at last gets stuck on Genshi. I don't understand how to get out of this since i have python 3.2 and it is failed for 3.2 on windows. Any idea!

on 6/26/13, 9:17 AM

Oh come on evon! It is very easy,I am sure you can do it. I already gave you simplest example. If you know how to call a method from sxw then it is very simple you don't even need any params while calling the method for total. You just need to write [[ your_method() ]] in rml or sxw at the end.That's it. I prefer you just to try it. If you are stuck in between, we members are here & ready to help :)

on 6/26/13, 9:27 AM

have you checked properly there are more methods related to that report file in stock.py too

on 6/26/13, 9:33 AM

I have checked RML file price_total() is called to do total. Same as you need to define method in rml file & in report.py file and return the global variable in which you have done calculation.

on 6/26/13, 10:24 AM
kirti joshi
On 9/12/14, 6:00 AM

I am using sum_field in aeroo reports but it gives error that  iteration is not allowed on browse_record .

please clearify your question?

on 9/12/14, 6:10 AM

I want to sum up one numeric field from my table for all the employees as a grand total of tabular data . Using aeroo report i am able to fetch the fields from the database but when I use sum_field function to add the elements it gives me error that iteration is not allowed on browse_record . Please help me for how to use extra functions of aeroo reports.

kirti joshi
on 9/16/14, 2:55 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

4 follower(s)


Asked: 5/16/13, 7:51 AM
Seen: 8491 times
Last updated: 3/16/15, 8:10 AM