topic Re: Calculation formula not working in ArcGIS Survey123 Questions

Calculation formula not working

GISManager4 — Fri, 19 Nov 2021 20:42:03 GMT

I want to build a calculation that returns the sum from integer fields and display them in a text field, but it is not working. I have tried everything I can think of. Followed instructions from Formulas site.

${GI1}+${GI2}+${GI3}+${Detention_Fac}+${Detention_Fac2}

I have the xsl file attached.

Re: Calculation formula not working

JayantaPoddar — Fri, 19 Nov 2021 21:46:33 GMT

You have used the text fields for calculation. You should use

${Num_GI1}+${Num_GI2}+${Num_GI3}+${Num_Detention_Fac}+${Num_Detention2}

Also change the Type of Num_Detention2 to integer.

Re: Calculation formula not working

GISManager4 — Mon, 29 Nov 2021 19:04:13 GMT

I made the changes you suggested and the calculation still does not work.

Re: Calculation formula not working

GISManager4 — Wed, 01 Dec 2021 22:04:33 GMT

The calculation field is not adding the fields together. It will show the value for 1 field, but as soon as I use + the formula does not work.