Batch Macro Error unsure how to resolve

Question

Hey all,

I have a batch macro in my workflow that I am using on 5 different sets of input data - 4 Qs in 2019 and 1 Q in 2018 data. The 2018 data seems to be formatted the same (besides the fact that I had to shift the rows up three times). I can't tell why the batch macro isn't working for this particular input but is working for the other 4 inputs. Included are screenshots of the workflow.

The error is relating to the formula tool selected here in the second picture

Can anyone tell me how to resolve this error? If any additional info is needed, please let me know.

DavidP · Accepted Answer

Hi @BSmithdubz

It looks like the data in the other 4 is getting loaded into a string data field. Most likely there is a character somewhere in that column that is not a number. It could even be a row that just has a space in it. Try loading the data separately and use a select tool to change the type to numeric. If that works, do the same inside the macro.