4 Replies Latest reply: Mar 1, 2018 2:45 AM by Ivan Bozov RSS

    Remove Records that have Credit  and Debit

    Salamon Musayev

      Hello

       

      I have a charges table with certain products having charge made that was subsequently canceled.  I need to remove those records from the data set. 

       

      The table look something like this 

       

       

      Acct #TestUnit CountCharge
      111CT 200.001
      111CT-200.00-1
      112MRI100.001
      112MRI-100.00-1
      112MRI100.001
      113CT200.001

       

      The result I am looking for is the following

       

       

      Acct #

      Test
      Unit Count

      Charge
      112MRI1001
      113CT2001

       

      The Acct#  111 needs to be completely removed and Acct #112 needs to have only 1 record and Acct #113 should be present.

       

      I have tried using the sum function in the load editor but its not giving me the result Im looking for.  I might be doing it wrong.

       

      Please help me or point me to the right direction.

       

      Thank you,