Register

Effective date of Employee in a Location

ShivankurSharma
Certified Master Anaplanner

Effective date of Employee in a Location

Hi,

 

Looking for a solution to get the effective date for working on a location(Result(output Required)).

 

Employee 1

1. Got hired on 15th March so output to be 15th March for the period March.

2. Moved to US location in May and stayed there for 3 months, for July period the result to be 31st May(period since working at that location).

3. Moved back to India in August, and been working from same location thereafter, so every period return once generated should give the result as 31st Aug (period since working at that location)

4. and this may go for multiple location change

 

How can we formulate this to be working

 

Sample:

Date(Period end return)Employee NameWork CountryEffective Start DateResult (output required)
31-03-2020Employee 1India15-03-202015-03-2020
30-04-2020Employee 1India15-03-2020 
31-05-2020Employee 1US15-03-2020 
30-06-2020Employee 1US15-03-2020 
31-07-2020Employee 1US15-03-202031-05-2020
31-08-2020Employee 1India15-03-2020 
30-09-2020Employee 1India15-03-2020 
31-10-2020Employee 1India15-03-2020 
30-11-2020Employee 1India15-03-2020 
31-12-2020Employee 1India15-03-202031-08-2020

 

 

THANK YOU !!

4 REPLIES 4
Akhil.kohli
Frequent Contributor

Re: Effective date of Employee in a Location

Hi Shivankur,

Can you try on below lines

IF Work Country <> PREVIOUS(Work Country) AND Work Country = NEXT(Work Country) AND Work Country <> BLANK THEN End ELSE BLANK

Thanks
AK
ShivankurSharma
Certified Master Anaplanner

Re: Effective date of Employee in a Location

Hi @Akhil.kohli 

 

Time is not a dimension to the module. It's just a line item. Previous will not be working.

 

Thanks,

Shivankur

Akhil.kohli
Frequent Contributor

Try using Lookup then, creating a previous time line item...

Try using Lookup then, creating a previous time line item in the system module for the time list

nathan_rudman
Master Anaplanner/Community Boss

Re: Effective date of Employee in a Location

effective dating should be starting off a transaction list like this.
use this to import in a time module with employee 1 and their country/date of start over time

Nathan Rudman, Anaplan Model Builder