Crew Macro Add Totals: No field selected for row totals ERROR

[mithily]

I am using the crew macro but keep getting this error:
No field selected for row total? Can you please help

[echuong1]

Looking at the underlying macro for this tool, it will throw that error if nothing is selected for the row total label. Can you check to see if you have something selected in here? 

[mithily]

When I look at that drop down there are no values in it, so I cannot choose anything. Should I create a dummy field to populate that. There is no documentation on how to use it. ty for your reply.

[echuong1]

You don't actually need that option. Just uncheck the box for that section.

[mithily]

I still get the error no matter what. Can you post a small sample and thank you for helping

[echuong1]

Would you be able to upload a copy of the data you're trying to use?

See attached for an example. I added row totals for two columns.

[mithily]

Many thanks, I am attaching the file I used. it is the sample crew macro but any data I use, I get the same error. Am I using an old version of crew macros? Can you point me to the version I should use. This is an awesome community, thanks for looking into this. 

[echuong1]

Hmm, what is odd is that it is actually still producing the output, along with the error message. Are you seeing the same thing?

[echuong1 · Accepted solution]

I think the issue is because you don't have any non-numbers in the dataset. It doesn't have a differentiation as to what each row means. Adding another non-numeric column that acts as a label for each row resolves the error. I'm assuming this is just a check built into the macro since generally, you'd want some sort of differentiation for each row. However, it looks like the tool still outputs as expected without it and just throws that error message.

Hope this helps! 

[mithily]

perfect ty