Concatenating within a conditional statement

Question

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.

Conditional statement issue.jpg

ChrisTX · Accepted Answer

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

Deano478 · Accepted Answer

@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())