6 Replies Latest reply: Feb 13, 2017 3:15 AM by yolanda21 yolanda21 RSS

    If Statement not showing correctly but has no error

    yolanda21 yolanda21

      Hi,

       

      I have the below statement that shows without error, but is only giving 1 scenario instead of both.

      Please assist

       

      =if(Closed_Date =' ' AND [Sbu_Desc]='UNKNOWN'

        ,'Complaint In Progress',

      'Known')