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