Re: [GNC] apply a factor to profit/loss report

2021-05-18 Thread Peter Münster
On Tue, May 18 2021, D. wrote: > But really, the best solution is to munge the data in a spreadsheet. I understand. But I would like to avoid that. Perhaps because of my habits. I've never used a spreadsheet before... -- Peter ___ gnucash-u

Re: [GNC] apply a factor to profit/loss report

2021-05-18 Thread Peter Münster
On Tue, May 18 2021, D. wrote: > it's entirely in the realm of possibility to do that-- if you have > that ability. I don't know, if I have. I have some experience with Common Lisp and Emacs Lisp. And I guess, that I should - copy the income-statement.scm to a new file - make some changes, so tha

Re: [GNC] apply a factor to profit/loss report

2021-05-18 Thread Peter Münster
On Tue, May 18 2021, Derek Atkins wrote: >> Is it possible to apply a factor (or coefficient) to accounts in the >> profit/loss report? > > No. Thanks for your fast answer. How much work would it be to patch Gnucash, to add that option? > Your best best is to extract the report and import it i

[GNC] apply a factor to profit/loss report

2021-05-18 Thread Peter Münster
Hi, Is it possible to apply a factor (or coefficient) to accounts in the profit/loss report? And if yes, then how please? Example: there is an account X with 100€, but I want to use only 70% of the amount in the report, that is 70€. TIA for any help. Kind regards, -- Peter __

Re: [GNC] apply coefficient to an account

2019-03-06 Thread Peter Münster
On Wed, Mar 06 2019, elvis wrote: > I have a program in python to add a split like that to a qif file. > [...] > if you are interested let me know. Thanks. But for my usage, it won't work: the split must be done later after importing the bank-files. -- Peter _

Re: [GNC] apply coefficient to an account

2019-03-06 Thread Peter Münster
On Tue, Mar 05 2019, Stephen M. Butler wrote: > Oh, are you using a Sqlite data store?  If so, you might be able to > write a query to pull those accounts and apply the percentages.  You > could load the account names and percentages into a new table and drive > the query from there. Thanks, good

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Peter Münster
On Tue, Mar 05 2019, John Ralls wrote: > Just edit the transaction and add a split. You can type '.3*123.45' and > '.7*123.45' in the expense debit column, no need to get out your calculator. Sure. But how can I split *all* transactions of an account the same way? The only way, that I know, is to

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Peter Münster
On Tue, Mar 05 2019, Stephen M. Butler wrote: > Could those accounts be treated similar to stock?  Or another > currency? I guess no. There are just 2 type of accounts: income in EUR and expense in EUR. All is imported from the OFX file of the checking account. Here is the result: http://pmrb.fre

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Peter Münster
On Tue, Mar 05 2019, John Ralls wrote: > You could just create two payroll expense accounts, one chargeable and > one not-chargeable and split the payroll expense between the two. The payroll expenses come from OFX files from the bank. After importing, how can I split 30% into one account and 70%

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Peter Münster
On Tue, Mar 05 2019, Derek Atkins wrote: > I would recommend you run the existing P&L report, then take the output, > copy it into a spreadsheet, and then add your coefficients there. That would be my last resort. Just to show you, that this would be some work: - http://pmrb.free.fr/tmp/gnucash-e

Re: [GNC] apply coefficient to an account

2019-03-05 Thread Peter Münster
On Tue, Mar 05 2019, John Ralls wrote: > Apply the coefficients how and with what intended result? It's just a multiplication. If there is for example 1000€ in an account and 0.7 must be applied, then there must be 700€ instead of 1000€ in the report. Our kayak club has a contract with a public o

[GNC] apply coefficient to an account

2019-03-05 Thread Peter Münster
Hi, For a special report of type "Profit & Loss" I need to apply some coefficients to some accounts. For example 0.7 to the account "transport". Is this possible with Gnucash, and if yes: how please? Thanks in advance for any hints. Kind regards, -- Peter _