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

[Deva -]

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, gnucash-user-request at gnucash.org<mailto:gnucash-user-request at gnucash.org> wrote:

Date: Sat, 13 Oct 2018 21:41:57 +0800
From: Christopher Lam <christopher.lck at gmail.com<mailto:christopher.lck at gmail.com>>
Cc: GnuCash users group <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:
<CAKVAZZ+nuEuD=c1brTWGHCqYqby1vODbRFHbbXFiHftNVEuM7A at mail.gmail.com<mailto:CAKVAZZ+nuEuD=c1brTWGHCqYqby1vODbRFHbbXFiHftNVEuM7A at 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 - <pobox.deva at outlook.in<mailto: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><mailto:
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><mailto:
christopher.lck at gmail.com<mailto:christopher.lck at gmail.com>>>
To: gnucash-user at gnucash.org<mailto: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><mailto:
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

________________________________