7 Replies Latest reply on Jan 24, 2019 11:21 AM by Deepak Rai

    Level of Detail Help

    Stephen Lanham

      Hi,

       

      I have this attached data set and I am trying to figure out who is moving in and out of the organization.  here are my notes that I have taken to hopefully explain what I am trying to accomplish:

       

      // if out of cost center and snap date is less than snap_date of in cost center then equals 'moved into'

      // if out of cost center and snap date is greater than snap_date of in cost center then equals 'moved out of'

      // if in cost center the whole time, then 'stayed put'

       

      // 107917 should equal 'stayed put

      // 298007 should equal 'moved into'

      // 444116 should equal 'moved out'

      // 565629 should equal 'moved out'

       

      I always appreciate any and all help.  I am sure this is a Level of Detail equation, I just can't figure it out.......going on 5 hours now