Formula Tool

guadalupemota

Hi,

I have a data set where on my "Xlarge bags" column there is an O instead of a zero. and down the column there's other numbers that should stay as is. I only need to change the alphabet letter O to 0.

I used the formula tool and I put:

IF [XLarge Bags] = "O"

THEN "0" 

ELSE "0"

ENDIF

However, this formula changed the whole columns to zeros and I only needed that row with O to change to 0.

Please advise!

Thank you,

Guadalupe  

fmvizcaino

Hi @guadalupemota ,

You should use the following:

IF [XLarge Bags] = "O"

THEN "0" 

ELSE  [XLarge Bags] 

ENDIF

Best,

Fernando V.