2 Replies Latest reply on Apr 8, 2013 6:43 AM by Ellen Pfeiffer

    Comparing Two Date Fields

    Ellen Pfeiffer

      Hi, I have a data set where each person has two date fields- SignUp_Date and Cancel_Date

      I want to show how many people signed up and how many people cancelled on any given day, and then the net growth. However, since the two dates are mutually exclusive, I can't figure out how to show how many of each happened each day.

      If I use Cancel_Date, it will just count how many people also have a SignUp_Date (which is everyone). If I add a calculation that says only when Cancel_Date = SignUp_Date then it will look for individuals who signed up and cancelled on the same day. And vice versa for Signup Date.

      I need to compare them as if they weren't connected to each other.

       

      Any ideas?