Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a list of records related to employees where I have the admission date (DD-MM-YYYY). I need to create a report where I can summarise the number of employees that I have in the company with more than 4 years, the ones that I have between 2 and 4 years and also the ones that I have until two years. What is the best option to do this?
I'd construct a table to define the brackets
You could script as:
LOAD
[YOS Bracket], YOS;
LOAD
[YOS Bracket],
Start+IterNo() as YOS,
Start,
End;
LOAD * INLINE [
[YOS Bracket], Start, End
'0-2',0,2
'2-4',3,4
'5+',5,99
;
Then for each employee calcuate a YOS field.