Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Saved search listing employees joining and leaving company by calendar month
Hi everybody,
In order to track employee turnover in our company, I'm trying to configure a saved search picking up the {hiredate} and {releasedate}, group them by calendar month, and sum up the respective joining or leaving employees' availability {custentity_emp_availability} as a positive amount when joining and a negative amount when leaving respectively. This is all pretty simple if I hardcoded the months into the individual columns. In that case, though, I would need to edit the saved search every now and then.
In order to make it dynamic and have the calendar month range extended, regardless of whether HR adds a new employee record with hire or release date two years into the future or five years in the past, I am facing the following two challenges.