Error in expression with multiple if conditions.

[#1]

Is  there anything wrong I am doing here? 

I have to calulate the sum([GL Post Amount] * (alt([Partnership Percent],1)))  for the below if conditions.

sum(IF([Source Code]='NFSC' ,
         IF(SECR_LVL_CD_1 <> 'INSURANCE',
          IF(SECR_LVL_CD_1 <> 'ANNUITY',
           IF(SECR_LVL_CD_1 <> 'ANNUITIES',
            IF(SecondTransactonTypeCode='FEE'))))),[GL Post Amount] * (alt([Partnership Percent],1)))

Thanks in adavance.

[pgrenier · Accepted solution]

Good day,

One thing is for sure, you can easily simplify your expression:

Sum(If([Source Code]='NFSC' and Match([SECR_LVL_CD_1], 'INSURANCE','ANNUITY','ANNUITIES')=0 andSecondTransactonTypeCode='FEE', [GL Post Amount] * alt([Partnership Percent],1) ,0))

Regards,

Philippe