8 Replies Latest reply on Jan 23, 2019 10:18 AM by andrew.schon

    Sum De-Duped Rows

    andrew.schon

      All,

       

      I've been trying to understand how FIXED works but I'm running into some issues. I have a dataset where I need to sum all records, but de-duplicate based on exact dates (including specific time) and interaction type. So if two records have the same interaction type and same date, de-duplicate them.

       

      Example:

       

       

      So in reality, the sum should be 2 after de-duping two records at 1/9/19 12:36 and two records at 1/9/19 11:50 (both expert conference call).

       

      thanks

      Andrew