Replace NULL with Value

[RAJAYKUMAR001]

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 solution]

Hi @RAJAYKUMAR001,

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 solution]

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

[DiegoParker]

Oh @Jonathan-Sherman beat me to it! Will need to get quicker next time 😛