Multiply by decimals

[nicktekippe]

I need to multiply the below fields by percentages and then add them up and multiply them by 10. I am receiving an error when trying to type the code out.

[ChrisTX · Accepted solution]

You'll need to convert [QBiC_R12] to a number.  Use the ToNumber function.

Here's a list of all functions: https://help.alteryx.com/20221/designer/functions

Chris

[Emmanuel_G · Accepted solution]

Hi @nicktekippe ,

This error is due to the fact that the QBIC_R12 column is a string type column.

You cannot multiply a column of type string to a float or numeric value.

It is thus necessary as a preliminary to convert the field QBIC_R12 in number.

Either by changing the type directly in the select tool in screenshoot, or by using a multi-field formula with the ToNumber function.

[grazitti_sapna · Accepted solution]

@nicktekippe, this would help.

Thanks!