Tracking employee\asset moves

Options
OSUBlakester
OSUBlakester Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

I'm looking for a way to track employee movements.   I have a transaction table to that includes Employee Number, Cost Center and Month values.  Is there a way that I can look up the Cost Center that was assigned to an employee from a previous month?  I know there is a PREVIOUS function that can pull numeric values, but wasn't sure if there was something similar that can pull the list member for a certain period.

 

Thanks

Tagged:

Comments

  • OSUBlakester
    OSUBlakester Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Occasional Contributor

    Hey Rob,

     

    Thanks for the quick response as always!  

     

    I hear what you are saying.  I think my problem is that I currently have my Employee list set up where the Employee is a child of a Cost Center.  (using the combination of Employee Number and Cost Center as the Code).  The same employee could exist under different cost centers.  This allows me to keep history when employees move.   I think what I need to do is create another Employee list without the Cost Centers and then use that to track the history.  

     

    I'll give that a try.  

Categories