4 Replies Latest reply on Mar 25, 2017 5:35 PM by Alex Marlow

    Help Removing Duplicates

    Alex Marlow

      I'm trying to work on a calculated field to remove duplicates from my data. I am unable to post the data source because it is too big.

       

      I have to join to on the same data to make sure all the data is consistent. However, that of course creates duplicates within the data. exp_amo is the column that I need and tra_id is the unique identifier for each value.

       

      Screen Shot 2017-03-25 at 3.52.02 PM.png

      Screen Shot 2017-03-25 at 3.53.54 PM.png

       

      Calculation that did not output the right result:

       

      Screen Shot 2017-03-25 at 2.32.58 PM.png

       

      If you have any questions, please let me know. I really appreciate your help!