Employee department Change

For example, Amit Kumar joined on 01/01/2020 in the sales department and transferred on 05/01/2021 to the finance department. I made a UX page where user can choose the leave date and the new department the employee has joined and run the action which will add a new List Item [ Amit Kumar ( Transfer) ] with a new Code (001T) in the Employee Hierarchy list.

Thus the Employee Details module will get updated with the Transfer Employee.

Now, the Leave Date of Amit Kumar in Sales will be the Join date for Amit Kumar ( Transfer) in Finance and the salary will be the same. But the challenge I'm facing is to copy these two cells' data, and I want to achieve this using formula. Help me with some hints.

Accepted answers

anirudh

Hi Soumya

When you run the transfer action, add another property against the transfered employee with the original Code. So against Amit Kumar (Transfer) also import the code of Amit Kumar - 001

Then create a line item with Employees list (same list) as dimension, format it with Employees and then do a FINDITEM against this code to get the original Amit Kumar. From there you can do Salary[LOOKUP: Original Code]

Let me know if this works

All comments

anirudh

Hi Soumya

When you run the transfer action, add another property against the transfered employee with the original Code. So against Amit Kumar (Transfer) also import the code of Amit Kumar - 001

Let me know if this works

SoumyadipKuila

Hi Anirudh,

Thanks for the hint. When I am using the lookup function it shows a data-type mismatch error.

anirudh

Can you share a screenshot of the source line item and the destination line item where it says Data-Type mismatch

SoumyadipKuila

Hey Anirudh,

I wasn't using the FINDITEM function initially. It is working now, the original salary is now mapped with the transferred employee.

Thank you for the help!

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385