Calculated Measure in Pivot and Graph View

Question

Hello,

Is it possible to add a calculated measure to graph and pivot view?

For example in Sale Order Tree View i click on Group by --> Partner.
In the Pivot i see the measures "Amount Untaxed" and "Amount Total". In these two columns i see the two totals for each partner.
I want to add the Measure ("Amount Total" - "Amount Untaxed").

So, if with the partner "Agrolait" the sum of Amount Total is 100$ and the sum of Amount Untaxed is 80$ i want to see in the other column the value 20$

i don't

Sylvain Michel Ratsarafahatra · Accepted Answer

Hi!

Yes, it possible.

1- First, create the field with the computed value (don't forget to create the method _compute_amount_diff)

amount_diff = fields.Float("Amoun Diff.", compute='_compute_amount_diff', compute_sudo=True, store=True, digits=(12, 6), readonly=True)

2- Second, add the field in your XML view

<pivot string="Sales Orders">
    <field name="amount_diff" type="measure"/>
</pivot>

Best regards!

Faisal Siddiqui · Answer

We have a module developed for this, please let me know if you need help in this regard.

Claudio Frigerio · Answer

Hi!

Thanks for the answer but i don't want to create a field. In my example 100$ and 80$ are not the value of the field "Amount Total" and "Amount Untaxed" but is the sum of the values of more records given by group_operator=sum

Related Posts	Besvarelser	Visninger
read_group multiple fields Løst community odooV11	1 okt. 20	18248
What’s the best architecture to manage multi-tenant odoo community setup with white-label support? community	1 okt. 25	1036
refresh screen save data automatically community	2 jul. 24	3352
tax location community	2 maj 24	8520
can not do invoice in community version community	1 feb. 24	2813

Dette spørgsmål er blevet anmeldt

Enjoying the discussion? Don't just read, join in!