1 2 Previous Next 15 Replies Latest reply on Oct 16, 2018 4:42 PM by Deepak Rai

    Absolute Enrollment vs. Discharged

    Josh Ciszek

      All,

       

      I need a Dimension for Enrolled vs. Discharged.  I have the following table example (see below).  If a client is still enrolled in AT LEAST one program (i.e. DisenrollDate is NULL), then assign the client as "Enrolled".  Otherwise, if the client is Disenrolled from ALL program, assign "Discharged".  I was experimenting with FIXED, but cannot seem to get the logic right.

       

      ClientID
      ProgramID
      EnrollDate
      DisenrollDate
      12344/6/20167/8/2016
      12357/9/2016(NULL)
      45641/1/201610/31/2066
      45653/1/20166/27/2016
        1 2 Previous Next