Formula tool making the whole column 0

[ShantanuDagar]

I am using formula tool to replace certain words with another in an existing column.

So using replace function.

And there are multiple words which need replacement so using AND in between multiple replace().

But after using that, all values in the column turn to 0.

Standalone 1 expression for 1 word replacement is giving right result but clubbing together multiple gives all 0

What is the issue?

[DataNath]

Yep exactly @BS_THE_ANALYST - I also think for a larger list of targets then lookup tables are cleaner/easier to maintain, especially if handing over workflows etc. But for cases where there's 2-3 changes needed a Switch() is sometimes just a nice alternative!