Survey 123 Calculate Field Causing Parsing Errors

ClaytonWells

Hello,

I am new to survey123 and still trying to figure out the syntax in the XLSX Form through Connect. I have attached a copy of the form as well as a sheet with the specific cells I am having problems with. I am trying to do some bridge scour calculations within the survey123 field app so that surveyors on the ground can easily get answers from their input data that will help them fill out the survey without having to do the math elsewhere. When I try to save the form to the survey it gives me an error saying that it cannot parse the fields which I have entered the calculations into. Any help would be appreciated but I think that the answer would be fairly obvious to any one of you survey wizards.

Thanks.

 

ClaytonWells

Hey Doug,

The underscore doesn't seem to be a problem, the survey created those field names and when changing them I received an error related to the removing of the underscore. 

Here is the error I am receiving. "b'ODK Validate Errors:\n>> XForm is invalid. See above for the errors. \norg.javaroasa.xform.parse.XFormParseException: Invalid calculate for the bind attached to "${froude_number_at_bridge_contrac}" : Unexpected beginning path in expression ${velocity_at_bridge_contraction} / (32.2 * (${flow_depth_at_bridge_contractio} * exp(0.5)))\n\nResult: Invalid'"