Not Wildmatch function

[sindisa12]

Good day.The first part of the expression below does not work when using "not wildmatch" function.  I have under Region ABC, Region A, Region B and Region C. Other Regions include D, E, F, G,H,I.

The first "if" statement should calculate the amount * Month3% if Region is D, E,F,G,H,I. The second "if" statement should calculate amount only if Region = A,B or C. This expression calculates correctly but the first one with "not wildmatch" function does not bring the correct results. what other function should i use instead?

if(match(Description,'New') and Line_ID <>20 and not wildmatch(Region, 'ABC*'),
Sum({<Line_ID_2 = {3} >} Amount * only(Month3%),

if(match(Description,'New') and match(Line_ID ,20 ) and wildMatch (Region, 'ABC*'),
sum( Amount),

[sindisa12]

Problem solved. Thank you all for your help

[Brett_Bleess]

Emelina, can you post what the final solution was and then use the Accept as Solution button on that post to mark it?  I can also mark Sunny's post if that is what ended up working, I just wanted to confirm.  You had marked a post that really did not make sense regarding it being the solution, so I unmarked that so as to not confuse folks coming across the post.

Thanks,
Brett