Skip to Content
This question has been flagged
projectpythonodoo12
1 Respondre
2797 Vistes
Avatar
Gerson Carranza

In proyects, in every task i have a "total float field", and i need to sum the totals of tasks and render it in the project view, but only the tasks that are in the stage "To do".

this is my code, but is not working.

@api.depends('tasks.sum_total_cost')
    def todo_sum(self):
        todo = self.env['project.task'].search([('stage_id', '=', 'To Do')])
        for task in todo:
            task.sum_todo= round(sum(task.mapped('sum_total_cost')), 2)
Avatar
Descartar
Serge Mercado

What field is ejecuction?

Avatar
Kevin Cruz
Best Answer

You just need to apply the sum after filtering with the correct path.

Try this


@api.depends('tasks.sum_total_cost')
def todo_sum(self):
    todo = self.env['project.task'].search([('stage_id', '=', 'To Do')])
    for data in todo:
        if data:
            self.sum_todo = round(sum(todo.mapped('sum_total_cost')), 2)
Avatar
Descartar
Related Posts Respostes Vistes Activitat
Create Journal Entries whit code Solved
python odoo12
Avatar
Avatar
Avatar
2
d’ag. 25
6448
Two many2many fields related to each other inside one model Solved
python odoo12
Avatar
1
de juny 22
8415
how to make invoice date field readonly false for administrator after validating invoice in odoo12?
python odoo12
Avatar
Avatar
1
de set. 21
3284
Update tax in invoice line
python odoo12
Avatar
0
d’ag. 21
95
How do I find Average Cost Function?
python odoo12
Avatar
0
de jul. 21
172