Remove the second "if" on the second line!
Hi @Cassie_Shaw
Please break the 3 = check into two like below.
IF [# OF ONE TIME PAYMENTS] * [POSSIBLE FDB MULTI BENEFICIARY] = [EE CONTRACT FLAT DEATH_BENEFIT] AND
[EE Death Benefit Owed?] = "0.00"
THEN "Yes Multi"
ELSE "No"
ENDIF
Note: When you use the values inside "", then the incoming datatype should be string.
If its numeric datatype use without "" i.e 0.00 like that.
Many thanks
Shanker V
IF ([# OF ONE TIME PAYMENTS] * [POSSIBLE FDB MULTI BENEFICIARY]) = [EE_CONTRACT_FLAT_DEATH_BENEFIT] AND [EE Death Benefit Owed?] = "0.00" THEN "Yes Multi" ELSE "No" ENDIF
It might be good to change your [EE Death Benefit Owed?] to numeric as a heads up! In which case you would remove the quotes [EE Death Benefit Owed?] = 0
If any of the columns remain strings as you indicated, you can either change them beforehand with a Select tool to numeric or use the ToNumber function around each of the columns.
IF (ToNumber([# OF ONE TIME PAYMENTS]) * ToNumber([POSSIBLE FDB MULTI BENEFICIARY])) = ToNumber([EE_CONTRACT_FLAT_DEATH_BENEFIT]) AND ToNumber([EE Death Benefit Owed?]) = 0 THEN "Yes Multi" ELSE "No" ENDIF
@alexnajm - aha! Thank you - the "to number" worked perfectly! Appreciate the quick assistance!
No problem @Cassie_Shaw! Please accept the solution(s) when you can to complete this thread :)