How to replace a value in a column

Question

Hi!

I have discovered that a value (in the column Frete Realizado) in my data is wrong, and I need to replace it with the right one.

What I was trying to do is (random values just to exemplify) :

IF [Usina/Centro] = "1111"
AND [Código Cliente] = "1111"
AND [Descrição SKU] = "Name"
AND [Mês] = "June"
AND [DT] = "11111111"
AND [Remessa] = "11111111"
THEN 6133.49 <correct value>
ELSE [Frete Realizado]
ENDIF

But when I check a sum of the column Frete realizado before and after the formula tool, it doesn't change the total sum.

Does anyone knows how can I solve this?

caltang · Accepted Answer

Create a mapping table via a different sheet or use a text input tool with those dimensions and value to replace. Then join the dimensions of interest and take the correct value.

Your IF statement is probably referencing different columns right?

PuffinPanic · Accepted Answer

It sounds to me like one of your if clauses is not being met.

As an alternative to @caltang's solution I'd diagnose by putting the output into a separate column (temporarily), then adding one clause at a time to the if statement and running to see what the output is. This will let you see what is causing your if statement to drop through to the else clause.