0

How to calculate the employees seniority

Carsten Clement

January 11, 2018 08:24

Answered

Follow

I will calculate the employee's seniority by adding the employee's employment date. However, the "seniority date" field in my Navision database can not be summarized as it is at date field. Does anybody know if it is possible, with a Jet report formula, to change the "seniority date" to  integer that can be summed up? Or do I have to list all the employees in Excel with there employment date to calculate the sum?

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis January 11, 2018 15:31

  While I don't understand how adding all date values together is helpful, this function should do it for Dynamics NAV:

  =NL("SUM","table_name","=VALUE(NF(,""date_field""))")

   

• 0
  
  Carsten Clement January 15, 2018 13:47

  Thanks a lot, it works like it should. With the formula you stated divided with the number of employees, I can calculat the avarage employment date and the seniority of the avarage employee.