Get Employee Salary in Corresponding Month Till the Employee Terminates.

[harshal98]

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.

[atcodedog05]

Hi @harshal98 

Can you provide this data as excel.

[harshal98]

Please find the Excel Sheet Below!

[harshal98]

Hi @atcodedog05

PFB

[atcodedog05]

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 😀👍

[harshal98]

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!

[atcodedog05]

Oh ok 

Let me look into @harshal98