Concatenating within a conditional statement

[kas]

Hello,

I'm trying to write a conditional statement, but am receiving a malformed statement error that something at the end is wrong.

The logic is; if the field is NOT empty,  then that field should equal a $ plus that field.

It is a string field that I'm working with.

as written: IIF(!IsEmpty([Fund_Ending_Value_]) || [Fund_Ending_Value_] = '$' + [Fund_Ending_Value_])

current: 28.00

Desired: $28.00   (but only if that field wasn't empty)

image attached as well.

[ChrisTX · Accepted solution]

IF !IsEmpty([Fund_Ending_Value_]) THEN '$' + [Fund_Ending_Value_]

ELSE [Fund_Ending_Value_]

ENDIF

check out examples on the Functions page: https://help.alteryx.com/current/en/designer/functions.html

[kas]

I swear that was the way I tried it first,but was getting a different error!

Obviously I missed a detail then as well.

Thank you,

Kim

[Deano478 · Accepted solution]

@kas I'm a bit late to the party but if you wanna keep the IIF syntax you can do this:

IIF(!IsEmpty([Fund_Ending_Value_]), '$' + [Fund_Ending_Value_], NULL())

[kas]

Thank you! :)