SOLVED
What does this error message mean?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
niomimonteiro
6 - Meteoroid
‎10-06-2020
11:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
Labels:
- Labels:
- Help
4 REPLIES 4
Alteryx
‎10-06-2020
11:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
22 - Nova
‎10-06-2020
11:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎10-06-2020
11:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!
22 - Nova
‎10-06-2020
11:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help 🙂
Cheers and happy analyzing 😀
