Register

Length of Service and Tenure

jjconn13
New Contributor

Length of Service and Tenure

Hi, I'm currently having trouble figuring out the Length of Service List and Tenure columns in the SYS08 Sales Reps Details module. There is a Length of service module already built, but it is blank. So I am unsure what to base the population of this column on. Also, I built a Reps tenure range module to calculate the the tenure of each sales rep but I am struggling on how pull this back into the SYS08 Reps Details module. Any guidance would be greatly appreciated!

 

(SYS08 Sales Reps Details module)

jjconn13_1-1618815236938.png

(Length of service pre-built module)

jjconn13_3-1618815384079.png

(Sales Rep tenure range module)

jjconn13_4-1618815483159.png

 

 

 

 

 

2 REPLIES 2
ChrisHeathcote
Community Boss

Re: Length of Service and Tenure

@jjconn13 

A few steps need to pull this data across into SYS08.

  1. Update the summary settings in QU08 Sales Reps Tenure.Tenure Band to LASTNONBLANK.
  2. Use the following formula in SYS08 Sales Rep Details.Length of Service List; =QU08 Sales Reps Tenure.Tenure Band[SELECT:TenureBandList.All]

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
jjconn13
New Contributor

Re: Length of Service and Tenure

Thank you for the response, Chris. I have managed to solve the issue.