Oracle Case Statement using OBIEE

Question

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 1

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