Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Derived Field for Length of Service
Thank you so much!!! :-)- amillis
- Post #4
- Forum: Strategic Reporting Systems(SRS): ReportSmith
-
Derived Field for Length of Service
I am trying to create a derived field that will show a certain number of leave accrual hours based on an employees length of service. If anyone with over 14 years receives 14 hours how do I write that? Here is what I have: @DECODE(REPORTS.V_EMPLOYEE.YEARSSERVICE,' 0','8 hrs','1','8 hrs','...- amillis
- Thread
- Replies: 3
- Forum: Strategic Reporting Systems(SRS): ReportSmith
