Retention Summary

[jamesmf1982]

Hi,

I have a chart that returns the length of an employees retention on an employee by employee basis using the following statement:

if(isnull(EmployeeLeaveDate), if($(v_date_max) - EmployeeStartDate<365,1,0))

This works fine, however I need to be able to summarise this to give the overall retention of the office. I have tried summing it and counting but neither work.

In addition on my table whilst I have the sum at the top of the table it does not return any values.

Any help would be great.

James

[sunny_talwar]

Can you try this

Sum(If(IsNull(EmployeeLeaveDate), If(Max(TOTAL  CalendarDate) - EmployeeStartDate < 365, 1, 0)))

[sunny_talwar · Accepted solution]

Only thing I see off is the set analysis on StartDate... try this

Count({<EmployeeStatus -= {'Permanently Inactive'}, EmployeeStartDate = {"$(='>=' & Date(Today()-365))"}>} EmployeeCode)

[jamesmf1982]

Awesome! Thanks for that