Community mailing list archives

community@mail.odoo.com

Re: V9E financial report: add formula referencing previous period

by
Ygol InternetWork, Yves Goldberg
- 08/20/2016 07:02:11
@fabien I did carefully had a look.
Do your imply it is already possible to reference a previous period within the same formula? 

ie: to get expenses variation to previous displayed period

balance = expense.balance / expense.balance.previous_period





----- Original message -----
From: Fabien Pinckaers <fp@odoo.com>
To: Community <community@mail.odoo.com>
Subject: Re: V9E financial report: add formula referencing previous period
Date: Fri, 19 Aug 2016 14:52:37 -0000

Have a look at the formulas behing the executive summary report for examples.


On Aug 18, 2016 11:43 PM, <info@ygol.com> wrote:
Hello,

Does anyone have an idea what it would take to add to the V9E financial reports a new available object to use in formula?

Thinking about being able to reference previous period in formula .
Something like:

balance = EXP.balance / EXP.previous_balance

This would allow showing variation between two periods in reports:

                      Period       Period-1
expenses        150             100
variation            -                1.5


Thank you.



--
Yves Goldberg - איב גולדברג
odooOfficial Partner - OCA member
Open Source ERP, CRM & CMS


Raanana [ISRAEL]

LinkedIn  Skype  Github  Quora 
--


_______________________________________________
Post to: mailto:community@mail.odoo.com



_______________________________________________
Post to: mailto:community@mail.odoo.com