https://community.esri.com/t5/arcgis-survey123-questions/simple-calculation-or-so-i-think/m-p/1537322#M59067 <P>I tested this on a similar form of my own.&nbsp; Oddly it looks like you need a leading zero in your factor, if you change it to 0<SPAN>.02953 instead of&nbsp;.02953 it should work.</SPAN></P> Wed, 11 Sep 2024 14:27:37 GMT MobiusSnake 2024-09-11T14:27:37Z https://community.esri.com/t5/arcgis-survey123-questions/simple-calculation-or-so-i-think/m-p/1537289#M59063 <P>I am pulling data from openweather api and I am trying to convert the pressure hPa into mercury inches so I would take the hPa and multiply it by .02953 to convert it to mercury inches. Attached is the rows from my xls forms and it is pulling the hPa correctly but returning a 0 for my second column for barocalc. What am I doing wrong?</P> Wed, 11 Sep 2024 13:34:08 GMT https://community.esri.com/t5/arcgis-survey123-questions/simple-calculation-or-so-i-think/m-p/1537289#M59063 jeffhyderBRVA 2024-09-11T13:34:08Z https://community.esri.com/t5/arcgis-survey123-questions/simple-calculation-or-so-i-think/m-p/1537322#M59067 <P>I tested this on a similar form of my own.&nbsp; Oddly it looks like you need a leading zero in your factor, if you change it to 0<SPAN>.02953 instead of&nbsp;.02953 it should work.</SPAN></P> Wed, 11 Sep 2024 14:27:37 GMT https://community.esri.com/t5/arcgis-survey123-questions/simple-calculation-or-so-i-think/m-p/1537322#M59067 MobiusSnake 2024-09-11T14:27:37Z https://community.esri.com/t5/arcgis-survey123-questions/simple-calculation-or-so-i-think/m-p/1537723#M59101 <P>Yep I have seen this a number of times.&nbsp; Need the leading 0 for sure.</P> Thu, 12 Sep 2024 12:52:36 GMT https://community.esri.com/t5/arcgis-survey123-questions/simple-calculation-or-so-i-think/m-p/1537723#M59101 DougBrowning 2024-09-12T12:52:36Z