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

相關帖文	回覆	瀏覽次數
read_group multiple fields 已解決 community odooV11	1 10月 20	17296
refresh screen save data automatically community	2 7月 24	2399
tax location community	2 5月 24	3699
can not do invoice in community version community	1 2月 24	1935
Access logs on Odoo Community 已解決 community	1 11月 22	5759

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！