Hi Community,
Looking for some help please I'm trying to pull back the country code from our route column if the country column for that SO line is blank (empty)
My formula is
IIF(isEmpty([Country]), TrimRight([Route], "2") but I'm getting an Error:
Formula (18): Parse Error at char(48): Malformed If Statement (Expression #3) see attached
Can someone please explain how I'd pull back UA from this UA-140
TIA
Karl.
Solved! Go to Solution.
Hey @Karl_Spratt ,
You need to include the false statement there or an additional parenthesis. Both are correct, it depends on what you are trying to do.
IIF(isEmpty([Country]), TrimRight([Route]), "2")
IIF(isEmpty([Country]), TrimRight([Route], "2"),"")
Best,
Fernando Vizcaino
Editing my response. I just saw your image and since you are trying to get the first 2 characters, your expression needs to be like this.
IIF(isEmpty([Country]), left([Route], 2),[Country])
thanks that worked. Really appreciate it..
Cheers,
Karl.