nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Analyze Survey Error

wysorj

I am trying to use the Analyze survey tool in Survey123 Connect (v. 3.18.123). I get the following error when it is run:

I have analyzed several other surveys without issue.

What's going on?

Thanks.

Find more posts tagged with

Accepted answers

ZacharySutherby

Hello @JimW,

Do you have a value in your calculation column that is just a number? Would you also be able to pass along your XLSForm for review on our end?

What's likely happening is there may be a value in the calculation column of your XLSForm that is an integer and the tool is failing because it's trying to compare a string to that integer. If this is the case this is a bug on the tool side.

All comments

wysorj

That was the issue. I had the number "1" in my calculation cell. I deleted it, ran the analyzer, fixed my file and then added the 1 back into the file.

ZacharySutherby

Hello @JimW,

Do you have a value in your calculation column that is just a number? Would you also be able to pass along your XLSForm for review on our end?

wysorj

Hi Jay.

Thanks for the reply and the suggestions.

Unfortunately, my XLS file was already closed and I already updated the XLS form to the latest version.

jhodny@Newark.de.us_CityOfNewarkDE

Hi Jim,

I found that if I run the tool with my XLS file still open, I get that error. If I then close, the tool runs. I also update the XLS form if it's an older version.

Regards, Jay

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.