You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Help with Case When statement

We need to derive a Vacation Tier based on either the Assignment, Job, or Years of Service for an employee. It needs to first look at the Vacation Tier field on the Assignment and if the value is not NULL, then the report should return whatever value is there. If it is NULL then it should look at the Eligible for Self Managed PTO field on the Job and if the value is Yes, then the Vacation Tier Derived column should return Tier3. If that value is No or NULL, then the logic should look at their Years of Service

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!