[GNC] Feedback: Balance Sheet (Multi-Column) / Income Statement (Multi-Column)

[Christopher Lam]

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 - <pobox.deva at outlook.in> 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, gnucash-user-request at gnucash.org<mailto:
> gnucash-user-request at gnucash.org> wrote:
>
> Date: Fri, 12 Oct 2018 22:04:40 +0800
> From: Christopher Lam <christopher.lck at gmail.com<mailto:
> christopher.lck at gmail.com>>
> To: gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>
> Subject: Re: [GNC] Feedback: Balance Sheet (Multi-Column) / Income
> Statement (Multi-Column)
> Message-ID: <b95c4659-4f44-f176-a85f-ab3bdca17f10 at gmail.com<mailto:
> b95c4659-4f44-f176-a85f-ab3bdca17f10 at gmail.com>>
> 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
> gnucash-user at gnucash.org
> 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.
>