Forum Discussion

4mkurtz71's avatar
4mkurtz71
New Member
2 years ago
Solved

New User need help with formula

I am trying to forcast when an employee will retire.   Our employees usually retire with 30 years of service and are between 50 and 55. I have the data for years of service and date of birth. I am ...
Need Help
Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

Hello 4mkurtz71 

 

can you please share a visual representation of what you would like to achieve ? 

 

 

best regards,

4mkurtz71's avatar
4mkurtz71
New Member
2 years ago
Nowage 55 & 30 years of service
in 1 yearage 55 & 30 years of service
in 2 yearsage 55 & 30 years of service
in 3 yearsage 55 & 30 years of service
in 4 yearsage 55 & 30 years of service
in 5 yearsage 55 & 30 years of service
  • 4mkurtz71's avatar
    4mkurtz71
    New Member
    2 years ago

     

    The data I have is below. I am trying to forecast expected retirements. Most employees will retire at 30 years of service and age 55. I would like to forecast for the next 5 years.

     

    How many employees are 50 and have 25 years of service

    51 and 26 years of service

    52 and 27 years of service

    53 and 28 years of service

    54 and 29 years of service

    55 and 30 years of service

     

    I want to slice it out in rank as well.

     

    Thank you for any help you can provide.

     

     

    EmplIDNameJob CodeJob TitleUnion CodeBirthdateAgeYears of ServiceYears till Age 55 & 30 Years Service