topic Rounding calculations in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/rounding-calculations/m-p/774379#M4634 <HTML><HEAD></HEAD><BODY><P>I'm looking for help with a calculation on my form. I want to round&nbsp;the numeric answer to a&nbsp;question divided by the product of a numeric answer to a question and a number. My formula is as follows:</P><P>round(${question1}div(${question2}*.01),2)</P><TABLE width="263"><TBODY><TR><TD style="border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: #9bbb59 black black; font-weight: 400; text-decoration: none; background-color: transparent;" width="263"></TD></TR></TBODY></TABLE><P>The calculation will not work on my form and I get no error message. Any help greatly appreciated.</P></BODY></HTML> Thu, 12 Jul 2018 19:42:22 GMT BryceHancock 2018-07-12T19:42:22Z Rounding calculations https://community.esri.com/t5/arcgis-survey123-questions/rounding-calculations/m-p/774379#M4634 <HTML><HEAD></HEAD><BODY><P>I'm looking for help with a calculation on my form. I want to round&nbsp;the numeric answer to a&nbsp;question divided by the product of a numeric answer to a question and a number. My formula is as follows:</P><P>round(${question1}div(${question2}*.01),2)</P><TABLE width="263"><TBODY><TR><TD style="border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: #9bbb59 black black; font-weight: 400; text-decoration: none; background-color: transparent;" width="263"></TD></TR></TBODY></TABLE><P>The calculation will not work on my form and I get no error message. Any help greatly appreciated.</P></BODY></HTML> Thu, 12 Jul 2018 19:42:22 GMT https://community.esri.com/t5/arcgis-survey123-questions/rounding-calculations/m-p/774379#M4634 BryceHancock 2018-07-12T19:42:22Z Re: Rounding calculations https://community.esri.com/t5/arcgis-survey123-questions/rounding-calculations/m-p/774380#M4635 <HTML><HEAD></HEAD><BODY><P>Make sure that you include the leading 0 in 0.01:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>round(${question1}div(${question2}*0.01),2)</P></BLOCKQUOTE><P></P><P><SPAN style="background-color: #ffffff;">Thanks</SPAN></P><P><SPAN style="background-color: #ffffff;">John</SPAN></P></BODY></HTML> Wed, 18 Jul 2018 00:59:15 GMT https://community.esri.com/t5/arcgis-survey123-questions/rounding-calculations/m-p/774380#M4635 JohnathanHasthorpe 2018-07-18T00:59:15Z Re: Rounding calculations https://community.esri.com/t5/arcgis-survey123-questions/rounding-calculations/m-p/774381#M4636 <HTML><HEAD></HEAD><BODY><P>Thank you. Is there a more comprehensive resource for calculations? What programming language is used for the formulas?</P></BODY></HTML> Wed, 18 Jul 2018 17:17:42 GMT https://community.esri.com/t5/arcgis-survey123-questions/rounding-calculations/m-p/774381#M4636 BryceHancock 2018-07-18T17:17:42Z Re: Rounding calculations https://community.esri.com/t5/arcgis-survey123-questions/rounding-calculations/m-p/774382#M4637 <HTML><HEAD></HEAD><BODY><P>Here you go:&nbsp;<A class="link-titled" href="http://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm" title="http://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm">Formulas—Survey123 for ArcGIS | ArcGIS</A>&nbsp;</P><P>These are based on the XLSForm standard:&nbsp;<A class="link-titled" href="http://xlsform.org/" title="http://xlsform.org/">XLSForm.org</A>&nbsp;</P></BODY></HTML> Wed, 18 Jul 2018 22:57:49 GMT https://community.esri.com/t5/arcgis-survey123-questions/rounding-calculations/m-p/774382#M4637 JohnathanHasthorpe 2018-07-18T22:57:49Z