Elijah Elijah - 3 months ago 9
SQL Question

Oracle Case Statement using OBIEE

CASE WHEN ("Candidate Cycle Time"."Time From Req. First Approval To Offer Accept"-"Requisition Aging"."Time On Hold Since Creation") < 6
THEN Null
ELSE "Candidate Cycle Time"."Time From Req. First Approval To Offer Accept"-"Requisition Aging"."Time On Hold Since Creation"
END


I have this case statement but need to add some info that is giving me a hard time.

So anything less than 6 should be null except for example values - 7654, 4567, 8013, 2038

How can I add this to my current case statement?

Answer
CASE
    WHEN ("Candidate Cycle Time"."Time From Req. First Approval To Offer Accept"-"Requisition Aging"."Time On Hold Since Creation")
       IN (7654, 4567, 8013, 2038) THEN ???
    WHEN ("Candidate Cycle Time"."Time From Req. First Approval To Offer Accept"-"Requisition Aging"."Time On Hold Since Creation") < 6 
       THEN Null 
    ELSE "Candidate Cycle Time"."Time From Req. First Approval To Offer Accept"-"Requisition Aging"."Time On Hold Since Creation"  
END 
Comments