In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

What does this error message mean?

niomimonteiro
6 - Meteoroid

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!

4 REPLIES 4
BrandonB
Alteryx
Alteryx

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
22 - Nova
22 - Nova

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
6 - Meteoroid

Thank you!

atcodedog05
22 - Nova
22 - Nova

Happy to help ðŸ™‚

 

Cheers and happy analyzing ðŸ˜€

Labels
Top Solution Authors