All About Cumulative Derived Columns


    While using Q&A you would like to generate a report that looks
like the one below, where Client ID#, Desc., Deposits, and Withdrawals
are fields, and the Running Balance is the cumulative balance for a
particular client and then reset to zero when the Client ID# changes.

    Client ID#    Desc.    Deposits    Withdrawals    Running Balance
    ----------    -----    --------    -----------    ---------------
          1111      101     $500.00        $438.17             $61.83
                    103     $500.00          $0.00            $561.83
                    104     $705.00         $25.00          $1,241.83
                    102     $500.00          $0.00          $1,741.83

          2222      103     $350.00          $0.00            $350.00
                    101     $800.00          $0.00          $1,150.00
                    102     $300.00          $2.00          $1,448.00

          3333      101    $1000.00        $200.00            $800.00
                    102    $1000.00        $200.00          $1,600.00
                    103    $2000.00        $700.00          $2,900.00



    Here's what you need to do...


    Create a Column/Sort Spec in Report as follows:

              Client ID#: 1,AS
                   Desc.: 2,AS,CS
                Deposits: 3
             Withdrawals: 4


    Press F8 on the Column/Sort Spec screen to create the Derived
Columns as follows:

                 Heading: Running Balance
                 Formula: ((#1=#20)*#10) +  #3 - #4
             Column Spec: 10

                 Heading:
                 Formula: #1
             Column Spec: 20,I











Q & A Application Note       Rev. 6/92           #2214     Page 1 of 1