Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Trying to make an overview for holidays per employee. Running into the following problem:
Regulations are in the sp_indicator table but different per employee. The valid from date differs as users may be later on the payroll than start of the year.
As I try to make a list of remaining holidays from last year or holidays for contractual rights the indicator type is different from the indicator_type_id field. To get the correct data I used the If statement in the overview table... however, I need a latest date per employee for each indicator type.
How can I do this?
Best regards,
Marco
.png "Luminary Alumni"){kind=icon}
Well I hope this is all fake test data. Otherwise you just posted some personal data. 
Use the scramble option (Document Properties - Scrambling) to scramble personal data (like names).