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

# Level of Detail Help

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

• ###### 1. Re: Level of Detail Help

how is 565629 moved out?

• ###### 2. Re: Level of Detail Help

This person was moved out and then back in (by error) and then back out again.  her actual last record looks like this:

565629 01/10/19 12/31/2199 out 15903

I had filtered out all the records with the date of 12/31/2199, that counts as the current record, but for that person, I would like to show they moved out in Dec instead of Jan.

makes sense?

• ###### 3. Re: Level of Detail Help

Here is the data with the 12/31/2199 rows in it, if it helps.

• ###### 4. Re: Level of Detail Help

Then you need to change your logic.

• ###### 5. Re: Level of Detail Help

You changed it for 298007 also, so here it is:

Thanks

Deepak

If it Helps, Pl mark it Helpful and CORRECT to close Thread

• ###### 6. Re: Level of Detail Help

Ok, well, let's take out the condition of showing in Dec and go with the logic to show the movement, I can explain one-offs.  Are you able to help me get started?