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
Hi Marco,
Sorry, this is confusing. Please can you post the QV document?
Thanks - DV
No probleem.. please find attached.
All test data but scrambled it anyway... thanks.
Best regards,
Marco
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).