Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
totalsumqweb-reportduplicated
2 Antwoorden
2324 Weergaven
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
Annuleer
Avatar
zulsani@vector-corrosion.co.id
Auteur Beste antwoord

.

Avatar
Annuleer
Avatar
Sreeraj Raghu, Sreeraj Raghu
Beste antwoord

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
Annuleer
zulsani@vector-corrosion.co.id
Auteur

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.

Gerelateerde posts Antwoorden Weergaven Activiteit
How to calculate total cost here?
total sum
Avatar
0
mei 15
5456
Create Subtotal on every page of a multipage QWeb Invoice
subtotal sum qweb-report
Avatar
Avatar
1
jun. 21
5566
Additional total on accounting reports
reporting total sum
Avatar
Avatar
1
nov. 16
4464
Compute the payslip batch total
payroll net report total sum
Avatar
0
mrt. 16
7393
Sum of sales in salesteam based on the hierarchy
salesteams sales total amount sum
Avatar
Avatar
1
okt. 15
5399