Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you
This works a treat
Thanks
Helen