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.
Solved! Go to 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
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.