Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

report program to calculate attrition rate or employee?

Former Member
0 Kudos

Hi all,

I have to prepare a report program to calculate the attrition rate.

I am done with most of the work, but i am confused about something.

I have made 4 parameters , and a date range.

So accordingly i am having my select queries.

But attrition rate requires, total employees before the daterange-low,

and newly joined, and left employees.

the queries will get the data only between the dates.

So how to get the total no. of employees before the starting date and the no. of left employees??

Any help would be apperciated.




Former Member
0 Kudos

there is a logical operator called LT, does that ring a bell 😛