If Statement not showing correctly but has no error

[#1]

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')

[kaushiknsolanki]

Hi,

You can try this.

If(Isnull(Closed_Date) and Wildmatch(Sbu_Desc = 'UNKNOWN'),'Complaint in Progress','Known')

Regards,

Kaushik Solanki

[#3]

Thanks but its giving me an error in expression and no result

[kaushiknsolanki]

Make sure that you have put correct name of the fields.

The expression it self will show where is the mistake by red line.

Regards,

Kaushik Solanki

[#5]

Its showing a red line at the bracket and comma between UNKNOWN and Complaint in Progress.

'UNKNOWN'),'Complaint in Progress

[kaushiknsolanki · Accepted solution]

Hi,

Sorry my mistake.

If(Isnull(Closed_Date) and Wildmatch(Sbu_Desc, 'UNKNOWN'),'Complaint in Progress','Known')

Try this.

[#7]

Its working!

Thank you sooooo much 🙂