3 Replies Latest reply: Jun 20, 2018 6:58 AM by kaan erisen RSS

    Identify Duplicate entries & additional clauses

    Jeffrey Lin

      I wanted to inquire if there's a expression code to test duplicate entries, test whether the duplicates has a flag with 1 'Debit' & 1 'Credit' and their value is the inverse of each other.

       

      Invoice NumberFlagValue

      10001

      Debit$1000

      10001

      Debit$1000
      10003Debit$5000
      10004Debit$8656
      10005Credit-$300
      10005Debit$300
      10006Debit$563

       

       

      Expected results:

      10005Credit-$300
      10005Debit$300

       

      Could this be done with a Variable & Expression code as I don't have access to reload the data.

       

      I've attempted to use

      Sum(Aggr(If(Count([Invoice Number)>1,1,0),[Invoice number]))

       

      This does find duplicates but only shows 1 entry and omits the other.