What does this error message mean?

Question

Hi,

I'm a beginner at Alteryx and decided to play around with a file. While using the formula tool to find Net earnings / Gross earnings %, I got an error message (as seen in attached picture) that I do not understand and hence am stuck. Kindly help!

Alteryx.JPG

BrandonB · Accepted Answer

You need to make sure that these columns are numeric data types. Can you add a Select tool before the formula and change these columns to double data types?

atcodedog05 · Accepted Answer

Hi @niomimonteiro

Its a Type mismatch. The field are not in Numeric they need to be in Numeric.

You convert to numeric by select tool or ToNumeric([Gross earnings]) on columns