Hope this helps.
Yes, you need kind of special join.
Your excel format is pretty Tableau-unfriendly.
1. need to use interpreter to convert joined cell.
And date format includes ". " <== be careful it contains space after period.
Thank for the screenshots -
For employee 22 - the expat status should also be for Nov aswell. You only have for Dec and Jan.
Please can you ammend. I could not.
5. Nov. 17 EUR Expat 0 Yes 6. Dec. 17 EUR Expat 0 Yes 7. Jan. 18 EUR Expat 0 Yes
--- you can see that from Nov - he became a expat.
22 Expat November 11, 2017
1 of 1 people found this helpful
BTW, you cannot see attached file from inbox, please go to original post always.
And if this helps, as forum manner, please mark my answer as Correct / Helped from original post.
So kind of you - thank you - help a lot!
So kind of you - you helped a lot
I do not understand the the join for the date condition - why does it have to be => - why do you need this conduction, I know it is critical - I played around with it.
I just do not understand.
I try and learn from all these posts.
If the person (Local - Expat sheet) in our example starts on the Nov 11th - so I need to state "include 19 days - i.e. to take the total number of the days in the month (nov has 30) and minus the number of days already employed (11 days). This is super critical for me providing exact data and I totally out of my capabilities at present.
Also I just thought of another complication, if the employee turned from being a local to expat, or an expat to a local (eg. in February) - I need to know how may day the employee was an expat and how may days the person was local
October 8, 2017 EUR No Status 0 November 8, 2017 EUR Expat -19 days 0 December 9, 2017 EUR Expat 0 January 9, 2018 EUR Expat 0 February 9, 2018 EUR Expat - 3 days - local 25 days 0 March 12, 2018 EUR Local 0
I have added a new updated tab file with different payroll date, copying with the join what you taught me.
I hope that is correct