Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEALiked this challenge, actually learnt a few things with it !!
Easy way
Hi Everyone,
I used nested IF ELSE to get the output.
IF IsNull([Address]) THEN "" ELSE [Address]+"," ENDIF
+
IF (IsNull([Apt/Unit])) THEN ""
else
IF IsNull([Zip]) THEN [Apt/Unit] ELSE [Zip] ENDIF
endif
+
IF IsNull([Address]) AND IsNull([Apt/Unit]) THEN [Zip] ELSE "" ENDIF
Please find my attached solution!