Noted. That explains my musings on period column numbers for some of the accounts.
Thanks for the clarification. Cheers. On 13-Oct-2018, at 8:20 PM, [email protected]<mailto:[email protected]> wrote: Date: Sat, 13 Oct 2018 21:41:57 +0800 From: Christopher Lam <[email protected]<mailto:[email protected]>> Cc: GnuCash users group <[email protected]<mailto:[email protected]>> Subject: Re: [GNC] Feedback: Balance Sheet (Multi-Column) / Income Statement (Multi-Column) Message-ID: <CAKVAZZ+nuEuD=c1brtwghcqyqby1vodbrfhbbxfihftnveu...@mail.gmail.com<mailto:CAKVAZZ+nuEuD=c1brtwghcqyqby1vodbrfhbbxfihftnveu...@mail.gmail.com>> Content-Type: text/plain; charset="UTF-8" You're welcome. As a side note about this "Average" - this is not strictly a 'monthly' average as such... instead, it's a 'column' average. This only matters if, e.g. your secondary-key is 'date', secondary subtotal is 'monthly', and expect Jan-Dec transactions. If there is 1 month missing i.e. transactions on every month except in November, then the subtotal-table will have 11 columns, and the average will be (Jan->Dec total) / 11. This is a limitation of the averaging function which divides total by number of columns, and is rather difficult, or very limiting, to try generate a true monthly average (i.e. I'm not keen of trying this). ~C On Sat, 13 Oct 2018 at 15:56, Deva - <[email protected]<mailto:[email protected]>> wrote: Thank you! That is an interesting use of Transaction report. Interpretation of the period columns is slightly different from what I had in mind, but this version of the report should give me what I am looking for, with a little adjustment in thought process. Cheers. On 12-Oct-2018, at 8:46 PM, [email protected]<mailto:[email protected]><mailto: [email protected]<mailto:[email protected]>> wrote: Date: Fri, 12 Oct 2018 22:04:40 +0800 From: Christopher Lam <[email protected]<mailto:[email protected]><mailto: [email protected]<mailto:[email protected]>>> To: [email protected]<mailto:[email protected]><mailto:[email protected]> Subject: Re: [GNC] Feedback: Balance Sheet (Multi-Column) / Income Statement (Multi-Column) Message-ID: <[email protected]<mailto:[email protected]><mailto: [email protected]<mailto:[email protected]>>> Content-Type: text/plain; charset=utf-8; format=flowed Hi Deva Thanks for feedback. Charts were planned but not quite finished. Period Average is actually present in the Transaction Report. Select either Asset/Liability accounts, or Income/Expense accounts, (or both). >From sorting tab, select Primary-Key = account-name, Secondary-Key = date, secondary-subtotal = month, Display / Subtotal table = enabled. You'll find monthly subtotals per account in the subtotal table. ~C ________________________________ _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
