I have the below statement that shows without error, but is only giving 1 scenario instead of both.
=if(Closed_Date =' ' AND [Sbu_Desc]='UNKNOWN'
,'Complaint In Progress',
You can try this.
If(Isnull(Closed_Date) and Wildmatch(Sbu_Desc = 'UNKNOWN'),'Complaint in Progress','Known')
Thanks but its giving me an error in expression and no result
Make sure that you have put correct name of the fields.
The expression it self will show where is the mistake by red line.
Its showing a red line at the bracket and comma between UNKNOWN and Complaint in Progress.
'UNKNOWN'),'Complaint in Progress
Sorry my mistake.
If(Isnull(Closed_Date) and Wildmatch(Sbu_Desc, 'UNKNOWN'),'Complaint in Progress','Known')
Thank you sooooo much :-)
Retrieving data ...