Odoo - one amount

Question

Odoo - one amount

I am working on a simple project and I have a problem. I want to sum one column in my one field, how can I do that?

from openerp import models, fields, api, _


class Fam(models.Model):
    _name = 'fam'

    fm_id = fields.Many2one('fam')
    mileage = fields.Float(string="Mileage", required=True)
    fueled = fields.Float(string="Fueled", required=True)
    perliter = fields.Float(string='Price per liter', required=True)


class Car2(models.Model):
    _name = 'car2'
    _description = 'Car record'
    _log_access = True

    name = fields.Char(
        string='Name',
        required=True
    )
    mile = fields.One2many(
        "fam",
        "fm_id",
        string='Mileage, Fuel and cost perliter',
        required=True
    )
    average = fields.Float(
        string='Average'
    )
    combustion = fields.Float(
        string='Combustion'
    )

+3

for-loop sum openerp

Ł.Strzelczyk Jul 19 17 at 10:53

source to share

1 answer

Bhavesh odedra · Accepted Answer · 2017-07-19T11:27:57+0000

You can achieve the following example:

for line in self.one2many_field_name:
    total += line.field_name_in_one2many_table

# in your case
total_mileage = 0.0
total_fueled = 0.0
total_perliter = 0.0  
for line in self.mile:
    total_mileage += line.mileage
    total_fueled += line.fueled
    total_perliter += line.perliter

Odoo - one amount

More articles: