What does this error message mean?

[niomimonteiro]

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!

[BrandonB · Accepted solution]

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 solution]

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

[niomimonteiro]

Thank you!

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀