Malformed IF Statement - Help Please

[Cassie_Shaw]

Morning community - Any help is appreciated. Data type is V-string for all.

[alexnajm]

Remove the second "if" on the second line!

[ShankerV]

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

[alexnajm]

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

[alexnajm · Accepted solution]

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

[Cassie_Shaw]

@alexnajm - aha! Thank you - the "to number" worked perfectly! Appreciate the quick assistance!

[alexnajm]

No problem @Cassie_Shaw! Please accept the solution(s) when you can to complete this thread :)