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]> 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]> wrote: > > Date: Fri, 12 Oct 2018 22:04:40 +0800 > From: Christopher Lam <[email protected]<mailto: > [email protected]>> > To: [email protected]<mailto:[email protected]> > Subject: Re: [GNC] Feedback: Balance Sheet (Multi-Column) / Income > Statement (Multi-Column) > Message-ID: <[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. > _______________________________________________ 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.
