Skip to Content
This question has been flagged
totalsumqweb-reportduplicated
2 Replies
1936 Views
Avatar
zulsani@vector-corrosion.co.id

Hi

I am working with Odoo enterprise web 16.4+e

I have Position table that taking positions from Employee table and showing the total of each position but currently if there are 2 same positions it will show it one by one. What I want is merging same position name and sum the total for that position as depicted below.

Is it possible to do this?

Any help will be appreciated. Thanks!


Avatar
Discard
Avatar
zulsani@vector-corrosion.co.id
Author Best Answer

.

Avatar
Discard
Avatar
Sreeraj Raghu
Best Answer

Hello,

If you need sum the total for that position only try to get it from "hr.job" model

or

new_dict={}
employee = search the employees based on your condition
for employee in employees:
	​if employee.position not in new_dict.keys(): #confirm whether the position exists
    	​new_dict.update({employee.position:1})
	​else:
	​	​​new_dict[employee.position]+=1



Avatar
Discard
zulsani@vector-corrosion.co.id
Author

Hi Sreeraj, thank you so much for your answer but I didn't get the "dictionary" you mentioned. Can you please elaborate more or give some example? Cheers.

Related Posts Replies Views Activity
How to calculate total cost here?
total sum
Avatar
0
May 15
5146
Create Subtotal on every page of a multipage QWeb Invoice
subtotal sum qweb-report
Avatar
Avatar
1
Jun 21
5256
Additional total on accounting reports
reporting total sum
Avatar
Avatar
1
Nov 16
4060
Compute the payslip batch total
payroll net report total sum
Avatar
0
Mar 16
6877
Sum of sales in salesteam based on the hierarchy
salesteams sales total amount sum
Avatar
Avatar
1
Oct 15
5095