topic Equation in relevant field not working, "unexpected beginning of path" in ArcGIS Survey123 Questions

Equation in relevant field not working, "unexpected beginning of path"

LouiseJ — Wed, 25 Mar 2020 19:46:59 GMT

I am working on a Survey123 form and trying to have a note appear when a set of parameters are within 10% of each other.

All the fields getting pulled are in the same group (as min and max have issues pulling from multiple groups).

max1 and min1 are working correctly, the issue seems to be coming from the formula in in the relevant field for calcstab1. Survey123 Connect is stating that it is an 'unexpected beginning of path'.

The end goal is that if this equation equals or is less than 10 it would show a note stating that it has stabilized.

Re: Equation in relevant field not working, "unexpected beginning of path"

Jim-Moore — Wed, 25 Mar 2020 23:48:20 GMT

Hi Louise

Thanks for the screenshot. In XLSForm, the operator for division is "div". If you replace the forward slashes with "div" this expression should work, i.e.

(((${max1}-${min1}) div ((${max1}+${min1}) div 2))*100)<=10

XLSForm operators and functions are described here: Formulas—Survey123 for ArcGIS | Documentation

Hope this helps.

Best,

Jim

Re: Equation in relevant field not working, "unexpected beginning of path"

LouiseJ — Thu, 26 Mar 2020 13:34:56 GMT

That's exactly what it is. Thanks!