| 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?
