Grouped if or else

[smilingjohn]

Hi All, 

Iam trying to created 3 rows in one field by grouping for which i am not getting the proper result . 

Below is my script can you please help on this . 

Script :

if(wildmatch(Dept,'AB','BC','AD'),
if(wildmatch(Sector,'Good','AVG'),
if(not wildmatch(Status,'Accepted','Proceed'),'Rejected')
and
if(wildmatch(Dept,'AB','BC','AD'),
if(wildmatch(Sector,'Good','AVG'),
if(wildmatch(Status,'Closed'),'In_Progress')
and
if(wildmatch(Dept,'AB','BC','AD'),
if(wildmatch(Sector,'Good','AVG'),
if(not wildmatch(Status,'Rejected'),'Built')))))) as Grouped,

Thanks in Advance

[Taoufiq_Zarra]

can you share a sample data and the expected output ? @smilingjohn 

[MayilVahanan · Accepted solution]

Hi @smilingjohn 

Can you try like below

if(wildmatch(Dept,'AB','BC','AD'),
if(wildmatch(Sector,'Good','AVG'),
if(wildmatch(Status,'Closed'), 'In_Progress',
if(not wildmatch(Status,'Accepted','Proceed'),'Rejected',
if(not wildmatch(Status,'Rejected'),'Built')))))as Grouped