Value changing after converting column from DOUBLE to STRING

[madhurinani]

Hello All,

I am facing an error as noticed by the client recently.

Step 1: I have created a new category column which is an nested if-else condition. Hence all the columns are in DOUBLE format. Works fine as expected.

Step 2: I convert the 3 columns in STRING as I need to append % symbol. (image attached)

Step 3: I create 3 formulas to append the %symbol for all the columns. 

Problem: When I use the step 2 SELECT logic to convert the from DOUBLE to STRING, my values in the Change column change.

Attached pics.

How Can i resolve this issue. Any help would be appreciated.
Ideally the value should be 0.08% only

[Emmanuel_G]

@madhurinani ,

As @PhilipMannering  said, do not change the type of Change field in select tool and you must create a new field with Tostring function.

Tostring works with a numerical field and the output is a string field.

If you do not want to create a new field, you can use a Mutli-Field Formula which replace the type inplace this field as shown in screenshoot below.

Find attached workflow which works.

Cheers !

[madhurinani]

@PhilipMannering , your solution worked as required. Thank you!

@Emmanuel_G , thank you for the workbook solution.