İçereği Atla
Bu soru işaretlendi
totalsumqweb-reportduplicated
2 Cevaplar
1289 Görünümler
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
Vazgeç
Avatar
zulsani@vector-corrosion.co.id
Üretici En İyi Yanıt

.

Avatar
Vazgeç
Avatar
Sreeraj Raghu
En İyi Yanıt

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
Vazgeç
zulsani@vector-corrosion.co.id
Üretici

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.

İlgili Gönderiler Cevaplar Görünümler Aktivite
How to calculate total cost here?
total sum
Avatar
0
May 15
4492
Create Subtotal on every page of a multipage QWeb Invoice
subtotal sum qweb-report
Avatar
Avatar
1
Haz 21
4574
Additional total on accounting reports
reporting total sum
Avatar
Avatar
1
Kas 16
3537
Compute the payslip batch total
payroll net report total sum
Avatar
0
Mar 16
6219
Sum of sales in salesteam based on the hierarchy
salesteams sales total amount sum
Avatar
Avatar
1
Eki 15
4557