Rolling up values into a new value in a different field

[#1]

Good Morning

I have the following sample data ( attached ). All I want to do is say

if Sales_Number begins with 9 then assign a new Region called  'Unrestricted'.

Thanks

[varshavig12]

Try this:

if(WildMatch(Sales_Number ,'9*',Region),'unrestricted',Region)

[#3]

Thanks Varsha. What's the 'a' for ?

[#4]

sorry ignore that ... my page had not displayed correctly

[varshavig12 · Accepted solution]

if(WildMatch(Sales_Number ,'9*',Region),'unrestricted',Region)

[trdandamudi]

May be as below:

=if(Left(Sales_Number,1)=9,'Unrestricted',Region) as Region

[varshavig12]

You got the desired output ?

[#8]

Unfortunately not. It doesnt return a region if you select any of the sales beginning 9,

[#9]

Perhaps I know why .... The Sales_number is actually referenced in another table which is the main table. The table provided in my sample is what's it doing a left join on and linking via the sales_number.

[#10]

Worked in the end. Thank you !