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

SURVEY 123 -Is there a way to have multiple numeric fields on the form, and the last one will sum/average/"Other math functions" the previous entries. Similarly if it's a percentage to assure the entries add up to 100%? Thanks in advance for any ideas

petegillard

Trying to average multiple numeric inputs on a Survey 123 form.

Find more posts tagged with

Accepted answers

UriGilad_EsriAu

Sorry, try

(${first_field} + ${second_field}+ ${third_field}) div 3

All comments

UriGilad_EsriAu

Hi Pete,

You can do this only if you're using Survey123 Connect (not the web version).

1. Create another row for your summary record, for example 'summary_field'.

2. Insert your equation in the calculation field of 'summary_field'. For example, to calculate the average of three other fields:

(${first_field} + ${second_field}+ ${third_field}) div 3

For more examples and operators see:

Formulas—Survey123 for ArcGIS | Documentation

Hope this helps,

Uri

petegillard

Hi, i keep getting this message when trying to update the form. Tried the field to calculate as 'calculate' or 'decimal' neither worked. the formula is in the 'calculation' field as written. am i missing something? thanks

UriGilad_EsriAu

Sorry, try

(${first_field} + ${second_field}+ ${third_field}) div 3

petegillard

Thanks! that did it!

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.