11 Replies Latest reply on Nov 20, 2018 7:20 AM by Paul Wachtler

    How to keep certain values from one field based on multiple conditions?

    n s

      I have data that included individuals with different statuses. My goal is to only show individuals that have two specific statuses at the same time. In the example below, I only want to keep individuals that have a status of A AND C.

      I tried a simple calculation:

      (IF [Status] = 'A' and [Status] = 'C' then "both" else "other" END)

      But it does not work.

       

      I would appreciate any assistance.

       

       

      Based on the table above, I would only want to show Frank Jones, James Carver,  and John Smith.