topic 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 in ArcGIS Survey123 Questions

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 — Mon, 10 Feb 2020 22:01:01 GMT

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

Re: 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

UriGilad_EsriAu — Tue, 11 Feb 2020 00:13:47 GMT

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

Re: 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 — Wed, 12 Feb 2020 14:50:48 GMT

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

Re: 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

UriGilad_EsriAu — Wed, 12 Feb 2020 23:12:12 GMT

Sorry, try

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

Re: 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 — Thu, 13 Feb 2020 14:06:57 GMT

Thanks! that did it!