Odoo Help


how to remove sum of total in group by

on 8/30/13, 7:40 AM 10,067 views

In OpenERP 7 List view time data added using the below code:-

'in_time' : fields.float('In Time'),

<field name="intake_time" widget="float_time"/>

In List view selected "Group by " any fields Header shows Total In time Value

How to remove Total In time value ? [in xml file not added sum keyword but group by still shows sum time ]

Pierre verkest
On 9/26/14, 5:35 PM


Probably a bit late!

You could override the read_group method like this on you model:

    def read_group(self, cr, uid, domain, fields, groupby, offset=0, limit=None, context=None, orderby=False):
        if 'intake_time' in fields:
        return super(MyClassName, self).read_group(cr, uid, domain, fields, groupby, offset, limit=limit, context=context, orderby=orderby)

I let a 'c' on the if condition, unfortunately, I haven't enough karma to edit my own post!...

Pierre verkest
on 9/26/14, 5:38 PM

I completely agree with this method, I tried it and it works! Thank you.

Karina Delgado
on 10/2/14, 2:02 PM

Thanks for this tip. It still work in Odoo 8.0

Camptocamp SA, Yannick Vaucher - Camptocamp
on 11/25/14, 7:11 AM

By the way I fixed the extra 'c'

Camptocamp SA, Yannick Vaucher - Camptocamp
on 11/25/14, 7:14 AM

Not too late at all. Thanks. Still works on Odoo 9.0.

Mathieu Laflamme
on 8/26/16, 4:31 PM

Ok after struggling with another issue on the pivot view, I figured out this hack is causing problem... seems like the pivot view is confused on the groups and javascript is crashing when selecting measures or "Expand all". I think the js code can be fixed to fully support the hack here and I will fill a ticket at Odoo.

Mathieu Laflamme
on 8/29/16, 3:35 PM

There is no issue with the pivot finally!!! Problem is that last line should be:

return super(ReportDetailInvoice, self).read_group(cr, uid, domain, fields, groupby, offset, limit, context, orderby, lazy).

Mathieu Laflamme
on 8/29/16, 5:39 PM

tks, it works, but I must change the first and last line

first line : ... , lazy=True) :

last line : ... , lazy=lazy)

Tai Le Thanh
on 6/7/17, 11:23 PM



| 5 4 7
Bikaner, India

OpenERP Developer at SunARC Technology

On 9/6/13, 6:01 AM

The default Float field value for group_operator shows sum of value

Reference link http://www.zbeanztech.com/blog/group-operator-openerp-grouping

Currently "Group by" Field values able to change to min, max, avg

But unable to remove group by value

i applied group_operator = None or group_operator = False but its still shows sum of total. How to group_by remove sum or set to value None

Any update?..


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 8/30/13, 11:26 AM

If the field has the tag sum in the tree view, when you use the group by you have the sum of all records. Remove the sum tag from view so you has'nt the sum when use group by


Naresh Soni (nch)

--Naresh Soni (nch)--
--Naresh Soni (nch)--

Team Lead, Odoo(Formerly OpenERP) Support & OPW

Naresh Soni (nch)
On 9/25/13, 6:52 AM

Hello Prakash,

By default OpenERP Will consider 'SUM' as group operator . So you wan't be able to remove this behavior easily by any sort of configuration or xml code. For this you need to make changes in the orm.py in def read_group method and comment out the code that adds the default 'SUM' to integer and float fields at line 2664.

Hope this helps !

Thanks for reply i will try

on 9/25/13, 7:41 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

1 follower(s)


Asked: 8/30/13, 7:40 AM
Seen: 10067 times
Last updated: 5/6/16, 10:50 AM