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.
Solved! Go to 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
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
@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())
Thank you! :)