Get Employee Salary in Corresponding Month Till the Employee Terminates.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Based On the Employee id, i want the salary to be displayed in Month fields till the last date of the Employee is found in the effective date column.
If two salary changes in same month, then the latest salary date of that month to be considered.
- Labels:
- Date Time
- Developer
- Developer Tools
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please find the Excel Sheet Below!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @atcodedog05
PFB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @harshal98
Is this what you are looking for.
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hI @atcodedog05,
This works there is just one thing i also have the year field so accordingly the salary fields are decided till the employee terminates or till today.
Request you to refer the excel file below you would get a better understanding on the same.
Please also note that excel sheet is the final format i want that is output........ i have only id, effective date, sal and year as my input columns and have to make entire data from that!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator