3 Replies Latest reply on Jun 14, 2016 10:05 AM by John Sobczak

    Filter Values in many to 1 results

    Michael Lahey

      Hello All,

      I have something that seems like it should be simple but I can't seem to make it work. I have a set of data with ID and another associated number. This number is entered as Pending as a placeholder and filled in later sometimes. When this happens I end up with a duplicate record for the ID. I would like to filter out Pending when an ID has another number, but keep the Pending when when it is the only result. Does anyone have any bright ideas how to approach this problem?

      WB attached