Replace NULL with Value

Question

Hi All,

I am Quite new to Alteryx.

I have been trying to replace NULL values on my AMOUNT column with value "5000"

I tried both Multi field formula and the formula tool but I am not able to phrase the formula.

it says that the phrase error.

Could anyone help me with the correct phrase to fix it.

The column Header is Amount and the null has to be replaced with 5000

Jonathan-Sherman · Accepted Answer

Hi @AJ_AJ,

you could do this with the following formula:

IF IsNull([Amount]) THEN 5000 ELSE [Amount] ENDIF

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

DiegoParker · Accepted Answer

Hi RajayKumar,

Please try: if IsNull([Field2]) THEN 5000 ELSE [Field2] ENDIF

Before:

After:

Hope this helps If does, can I ask you to mark it as the solution? this will help other users to find it and will allow us to close the thread. Many thanks!

Best,
Diego