Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
2 Replies
3616 Tampilan

Hello Odoo Community:

    I would like to see average margin_percentage in the sale list view. I used this code: 

   I am able to see the average value for all sale orders; however, when I grouped orders according to customers, average values become sum values for each group. How could I change it to average again? Thank you so much!

Avatar
Buang
Jawaban Terbai

Hi,

You can use the group_operator attribute to decide which value to see when using grouping.

group_operator="avg" gives the average value when grouping.


Here's an example for your reference:
margin_percentage = fields.Float(string="Margin Percentage",
                 group_operator='avg')


Hope it helps

Avatar
Buang
Penulis

Thank you so much!

Jawaban Terbai

The code is not visible, 

This is an example of showing Average 


Also odoo reference state the following regarding avg:
displays the corresponding aggregate at the bottom of the column. The aggregation is only computed on currently displayed records. The aggregation operation must match the corresponding field’s group_operator.

If you code was visible, I might be able to help you more

Avatar
Buang
Penulis

Thank you for your reply, but I cannot see the example you shown

Post Terkait Replies Tampilan Aktivitas
1
Agu 25
1040
1
Nov 22
3324
2
Apr 19
8426
1
Jan 24
16073
1
Mar 15
4308