How to create a new column which multiplies the value of an existing column by a number

[AlteryxUser001]

I would like to know the most appropriate tool to create a new column which multiplies the values of an existing column by a percentage e.g. 20% (0.20)

The column which needs to be multiplied contains zero values. 

I believe the "Formula" tool is the most appropriate, i can select add new column and name it accordingly however multiplying the column header name that i want by 0.20 throws up an error. 

[binuacs · Accepted solution]

@AlteryxUser001 Not sure i understand your requirement properly, based on my understanding you can create a new column using the formula tool something like below

[AlteryxUser001]

thanks for that - the error reads that I am trying to apply the formula to a string value - I guess I have to go back cleanse the data and ensure the column in question is numeric/double?

[binuacs]

@AlteryxUser001 you can use the toNumber() function to change the value into numeric. make sure no space followed by the fields 

[AlteryxUser001]

I apply To Number([column]) and run the formual tool, however when i add another forumale tool after that and follow your first step formula - i still get the error "tried to apply numeric operator to string value"

[binuacs]

@AlteryxUser001 @Check your first formula output data type is numeric or not? 

[AlteryxUser001]

Spoiler

it looks as the ToNumber formula is successful after I click run

[AlteryxUser001]

it looks as the ToNumber formula is successful after I click run

[AlteryxUser001]

all resolved now - it was the ordering of the tools for my specific spreadsheet I did not have correct.