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; } } }

I am trying to use the calculate feature in survey123 connect to generate a score by adding up all the fields.

LynneWarwick

I am trying to use the calculate feature in survey123 connect to generate a score by adding up all the fields. I have ran into an issue adding up more that 6 fields. I have the responses set as yes=1 and no=0, the survey will add up the first 6 fields, if add more fields to the equation, stops adding the responses and just displays the responses rather than adding them together. Any thoughts or suggestions?

タグ付きの投稿をもっと見る

Accepted answers

Katie_Clark

If you're doing a mathematical calculation, have all the fields been correctly set as number types?

All comments

Katie_Clark

If you're doing a mathematical calculation, have all the fields been correctly set as number types?

LynneWarwick

which fields do I need to make sure they are set as number types?

Katie_Clark

well, if you're trying to add numbers together, they would all have to be number types.

i.e. if you want 1 + 1 = 2, those are number types. If 1 + 1 = 11, that's text.

Here's a screenshot from the Survey123 documentation showing the syntax to use in your calculation to make sure they are all number types.

If you still have questions, sharing some screenshots of your XLS form might be helpful!

dougbrowning

Set the bind::type column to int and that should fix it.

LynneWarwick

Thank you! the cell where the calculation is, needed to be set (formatted) as a number.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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