Error messages in Alteryx

Question

Hi received these two error messages, if anyone has any recommendations please advise. Thank you!

summary issue.PNG

parsing error.PNG

Maskell_Rascal · Answer

Hey @njohn2756

Without being able to see more of the data or workflow, I can't really tell you what to set the Field Type to. If I had to guess, I'd probably say it needs to be changed to a Double.

Does your workflow use the Transpose or Crosstab tool at anytime prior to the formula tool with the error? If so, these tools convert all fields to a string, so you'd need to convert the number fields back to a Double or Byte.

You could try using the Auto Field tool prior to the formula tool to automatically convert doubles stored as strings. It will convert everything to the smallest possible size/type, so keep that in mind.

Before:

After:

Thanks!

Phil

njohn2756 · Answer

Hi Im unable to post the workflow due to work restrictions do you have any other suggestions? I appreciate the help.

atcodedog05 · Answer

Hi @njohn2756

Can you share your workflow and some sample data

So that we can look into it.