I am trying to use the contain function, but I have multiple criteria that I need to check for.
An example is: If AA = '85' and MAC = '813' and USSGL = 488100 or 498100 then 0709.
Is the expression below correct? Looks like the OR statement is throwing my output off.
IF [AA] = "85" AND [MainAccountCode] = "813" AND Contains([USSGL], "488100") OR
Contains([USSGL], "498100")
THEN '0709'