Match(If statement with 3 elements

[helen_pip]

Hello

I have written a match(if statement but it does not seem to be wokring correctly, although no errors turn up in the reload , although i do not get the desired results

If(Match(month_end_breach_risk_6wks, '3) Dated - in month breach', '4) Dated - month end breach'), 'Other', Match(month_end_breach_risk_6wks,'2) No date','No Date', 'Date In Time')) as Test

Could someone cast an eye over my If statement , what I want to achieve is 3 elements

1) Other

2) No Date

3) Dated In Time

Thanks

Helen

[kaushiknsolanki · Accepted solution]

Try this,

If(wildmatch(month_end_breach_risk_6wks, '3) Dated - in month breach', '4) Dated - month end breach'), 'Other',

if(wildmatch(month_end_breach_risk_6wks,'2) No date'),'No Date', 'Date In Time')) as Test

Regards,

Kaushik Solanki

[helen_pip]

Thank you

This works a treat

Thanks

Helen