Total of Selective Groups
Posted: Thu Jul 11, 2019 3:03 pm
From Internal Technical Support:
How can I selectively create a total for certain accounts on my general ledger financial statement but not show the individual accounts on my report?
If you don't wish to list the individual accounts and/or the accounts are scattered in the chart, do something like this:
Change each account reference as applicable, from 11000 to the accounts you wish to add together. The above example adds 4 accounts. If you need to add more, add extra lines like so:
You can or should change GRPTOTAL to a more meaningful label subject to the purpose of the addition. Such as VANCOSTS or whatever makes sense subject to the context.
The text:
Should, of course, also be changed to something relevant such as:
How can I selectively create a total for certain accounts on my general ledger financial statement but not show the individual accounts on my report?
If you don't wish to list the individual accounts and/or the accounts are scattered in the chart, do something like this:
Code: Select all
!@Add([PERIOD_BAL:11000], 0, &GRPTOTAL)
!@Add([PERIOD_BAL:11000], [&GRPTOTAL], &GRPTOTAL)
!@Add([PERIOD_BAL:11000], [&GRPTOTAL], &GRPTOTAL)
!@Add([PERIOD_BAL:11000], [&GRPTOTAL], &GRPTOTAL)
TOTAL OF GROUP XYZ: [&GRPTOTAL]
Code: Select all
!@Add([PERIOD_BAL:<your_chart_code_here>], [&GRPTOTAL], &GRPTOTAL)
The text:
Code: Select all
TOTAL OF GROUP XYZ: [&GRPTOTAL]
Code: Select all
TOTAL OF VAN OPERATING COSTS: [&GRPTOTAL]