AnsweredAssumed Answered

Case calculation won't return last test result

Question asked by zdevore on Nov 28, 2018
Latest reply on Nov 28, 2018 by zdevore

I have a case calculation that was working perfectly, until... We added another step in our procedure and I need to add a new if variable to the calculation

 

Case ( IsEmpty ( Date Follow Up Sent ) and IsEmpty ( Received Special )  and IsEmpty ( Date Quest Received); Follow Up Quest Needed

 

; not IsEmpty ( Date Follow Up Sent ) and IsEmpty ( Received Special ) and IsEmpty ( Date Quest Received); Date Restriction Needed

 

; not IsEmpty ( Date Follow Up Sent )  and  not IsEmpty ( Date Restriction Set ) and IsEmpty ( Received Special ) and IsEmpty ( Date Quest Received); ReMail Needed

 

; "")

 

I'm trying to add the last test to the calculation and no matter what I try I can't get it to work. The first two tests return the correct results, but the field stays on the Date Restriction Needed date when it should display the ReMail needed date.

 

I've done this in another database where I am adding to the Case calculation all the time and haven't had any troubles.

 

What am I not seeing here?

 

Thank you in advance

Outcomes