Total of Selective Groups
  • COBS Tech Support
    Posts: 678
    Joined: Fri Sep 09, 2005 8:23 am

    Total of Selective Groups

    by COBS Tech Support » 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:

    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]
    
    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:

    Code: Select all

    !@Add([PERIOD_BAL:<your_chart_code_here>], [&GRPTOTAL], &GRPTOTAL)
    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:

    Code: Select all

    TOTAL OF GROUP XYZ: [&GRPTOTAL]
    Should, of course, also be changed to something relevant such as:

    Code: Select all

    TOTAL OF VAN OPERATING COSTS: [&GRPTOTAL]

Who is online

Users browsing this forum: No registered users and 1 guest