Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
CASE WHEN
SRC_CD = 'NFSC' AND
SECR_LVL_CD_1 NOT IN ('INSURANCE', 'ANNUITY', 'ANNUITIES') AND
SCND_TRN_TY_CD IN ('FCR', 'FEE') THEN 'AMC Recurring'
Thanks in advance.
Maybe like
if( SRC_CD = 'NFSC' and not match(SECR_LVL_CD_1, 'INSURANCE','ANNUITY','ANNUITIES') and match(SCND_TRN_TY_CD,'FCR','FEE'), 'AMC Recurring')
You could try this:
sum({< SRC_CD = {'NFSC'} , SECR_LVL_CD_1 -= {'INSURANCE', 'ANNUITY', 'ANNUITIES'} , SCND_TRN_TY_CD = {'FCR', 'FEE'}>} [AMC Recurring])
Best,
Matt
One more:
if(SRC_CD='NFSC'
AND match(SECR_LVL_CD_1,'INSURANCE', 'ANNUITY', 'ANNUITIES')=0
AND match(SCND_TRN_TY_CD,'FCR', 'FEE'),
'AMC Recurring') as FieldName