1 2 Previous Next 27 Replies Latest reply on Oct 24, 2017 8:45 AM by Sherzodbek Ibragimov

# dates

Please can you let me know how to do this

I would like to know how many days late vacations payments are made.

I have the following

I just  need a formula that states that were the is vacation pay - take the termination date and minus this from the  last day of the month (in the month column)

 Emp Month Order Termination Vacation Pay Calc Field aa Jan 1 February 1, 2017 aa Feb 2 February 1, 2017 aa March 3 February 1, 2017 aa April 4 February 1, 2017 aa May 5 February 1, 2017 400 Vacation paid late  (ie. May 30th - Feb 1st) aa Jun 6 February 1, 2017 bb July 1 June 1, 2017 bb August 2 June 1, 2017 300 Vacation paid late  (ie. August minus  -June 1st) bb September 3 June 1, 2017

thanks

• ###### 1. Re: dates

David,

Please see if this calculations will help you to achieve what you are looking for:

1 of 1 people found this helpful
• ###### 2. Re: dates

By the way, can you provide me wit the WB you created - would you mind, only if you have

• ###### 3. Re: dates

Yeah sure, please see attached.

• ###### 4. Re: dates

I feed really stupid - how do add  the number of days and weeks late

• ###### 5. Re: dates

David,

Don't worry about feeling bad, it happens to all of us, even with me, sometimes the solutions doesn't ring right away so having someone to have a look is best way to save time. Tableau Community is all about helping each other. Please feel and never hesitate to post your questions in future, there will be always someone who can jump in to help you. Have a nice day.

Sherzod

• ###### 6. Re: dates

Can you add this to workbook please  -how do add  the number of days and weeks  between the vacation pay and the last termination date.

i appreciate your reassuring words

• ###### 7. Re: dates

For sure, please see attached and snapshot below:

1 of 1 people found this helpful
• ###### 8. Re: dates

I so appreciate the time and effort you put into this

cheers!!!!!!!

• ###### 9. Re: dates

You are very welcome. Glad I was able to help you with your questions.

Sherzod

• ###### 10. Re: dates

Hi

I have similar followup

I would like to know if there is any one who is getting paid base pay after their termination date

1. In example below - lucky employee AA - he terminated on Jan 15th 2016 and still not base pay for Feb and March

2. Employee BB is great - there is no termination date - so he should be paid.

 Employee Month Oder Month Base Pay Employee Termination Date Comments AA 1 Jan-16 1,000 AA January 15, 2016 AA 2 Feb-16 1,000 AA January 15, 2016 AA 3 Mar-16 1,000 AA January 15, 2016 AA 4 Apr-16 AA January 15, 2016 Paid 2 for months after last terimination date AA 5 May-16 AA January 15, 2016 Paid 2 for months after last termination date BB 1 Mar-16 2,000 BB NULL No termination date   -OK BB 2 Apr-16 2,000 BB NULL No termination date   -OK BB 3 May-16 2,000 BB NULL No termination date   -OK
• ###### 11. Re: dates

This analysis need to be per employee

• ###### 12. Re: dates

I do not see an option to add a file

• ###### 13. Re: dates

Can you add me the workbook like before please - I have it but do not see how to post it

• ###### 14. Re: dates

Ahh haaa I found it.

I have attached updated excel and tableaU file

1 2 Previous Next