Example Data: |
|
|
|
|
|
MJE Text |
Ref Fld 1 |
Ref Fld 2 |
Ref Fld 3 |
Date |
NTID |
Accrual |
MJE Load |
|
|
11/1/2019 |
DAVET |
Fx Reval |
Accrual |
|
|
12/2/2019 |
MOLLYI |
|
|
Acc |
|
3/4/2019 |
BOBH |
Forex Fx |
|
|
CCRUAL |
7/9/2019 |
GREGA |
FASB |
|
|
|
8/5/2019 |
BOT7 |
Tax |
|
|
|
10/6/2019 |
BOT88 |
I want to use contains to search multiple strings and "IN" for multiple targets within the same formula.
IF Contains(([MJE Text]+[Ref Fld 1]+[Ref Fld 2]+[Ref Fld 3) IN("Accrual","Acc","CCRUAL")) THEN "Accrual" ELSE "" ENDIF
Result would be: |
|
|
|
|
|
|
MJE Text |
Ref Fld 1 |
Ref Fld 2 |
Ref Fld 3 |
Date |
NTID |
Group |
Accrual |
MJE Load |
|
|
11/1/2019 |
DAVET |
Accrual |
Fx Reval |
Accrual |
|
|
12/2/2019 |
MOLLYI |
Accrual |
|
|
Acc |
|
3/4/2019 |
BOBH |
Accrual |
Forex Fx |
|
|
CCRUAL |
7/9/2019 |
GREGA |
Accrual |
Can this be developed?