topic Re: max calculate on 4 integer fields not returning the actual max integer in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/max-calculate-on-4-integer-fields-not-returning/m-p/775419#M4837 <HTML><HEAD></HEAD><BODY><P>It seems to be parsing fields 1 - 4 as text instead of numbers. I would try&nbsp;forcing them to be read as integers using int():&nbsp;<SPAN style="background-color: #ffffff;">max(int(${field1}), int(${field2}), int(${field3}), int(${field4})).</SPAN></P></BODY></HTML> Wed, 21 Aug 2019 13:20:12 GMT BrittneyGibbons1 2019-08-21T13:20:12Z max calculate on 4 integer fields not returning the actual max integer https://community.esri.com/t5/arcgis-survey123-questions/max-calculate-on-4-integer-fields-not-returning/m-p/775418#M4836 <HTML><HEAD></HEAD><BODY><P>I created an integer field with a calculation to display the highest number from 4 other integer fields.&nbsp; So for field ${highest_number}, the calculation is max(${field1}, ${field2}, ${field3}, ${field4}).&nbsp; Using these numbers as an example: 450, 290, 875, and 1285; 875 is returned as the max number because I assume it starts with the highest number but obviously 1285 is the highest number.&nbsp; Any ideas on what is going on?</P></BODY></HTML> Wed, 21 Aug 2019 12:49:39 GMT https://community.esri.com/t5/arcgis-survey123-questions/max-calculate-on-4-integer-fields-not-returning/m-p/775418#M4836 KatieWise 2019-08-21T12:49:39Z Re: max calculate on 4 integer fields not returning the actual max integer https://community.esri.com/t5/arcgis-survey123-questions/max-calculate-on-4-integer-fields-not-returning/m-p/775419#M4837 <HTML><HEAD></HEAD><BODY><P>It seems to be parsing fields 1 - 4 as text instead of numbers. I would try&nbsp;forcing them to be read as integers using int():&nbsp;<SPAN style="background-color: #ffffff;">max(int(${field1}), int(${field2}), int(${field3}), int(${field4})).</SPAN></P></BODY></HTML> Wed, 21 Aug 2019 13:20:12 GMT https://community.esri.com/t5/arcgis-survey123-questions/max-calculate-on-4-integer-fields-not-returning/m-p/775419#M4837 BrittneyGibbons1 2019-08-21T13:20:12Z Re: max calculate on 4 integer fields not returning the actual max integer https://community.esri.com/t5/arcgis-survey123-questions/max-calculate-on-4-integer-fields-not-returning/m-p/775420#M4838 <HTML><HEAD></HEAD><BODY><P>That did it!&nbsp; Thank you so much.&nbsp; I assumed it had something to do with that but wasn't sure the fix. </P></BODY></HTML> Wed, 21 Aug 2019 13:25:50 GMT https://community.esri.com/t5/arcgis-survey123-questions/max-calculate-on-4-integer-fields-not-returning/m-p/775420#M4838 KatieWise 2019-08-21T13:25:50Z Re: max calculate on 4 integer fields not returning the actual max integer https://community.esri.com/t5/arcgis-survey123-questions/max-calculate-on-4-integer-fields-not-returning/m-p/775421#M4839 <HTML><HEAD></HEAD><BODY><P>Glad that worked! That happens to me all the time. Some fields that I expect to be numerical are processed as text instead, especially if I am using a select one with numerical values.</P></BODY></HTML> Wed, 21 Aug 2019 14:35:24 GMT https://community.esri.com/t5/arcgis-survey123-questions/max-calculate-on-4-integer-fields-not-returning/m-p/775421#M4839 BrittneyGibbons1 2019-08-21T14:35:24Z Re: max calculate on 4 integer fields not returning the actual max integer https://community.esri.com/t5/arcgis-survey123-questions/max-calculate-on-4-integer-fields-not-returning/m-p/775422#M4840 <HTML><HEAD></HEAD><BODY><P>You can also use the bind::type column set to int on the fields you want to check.&nbsp;&nbsp;</P></BODY></HTML> Wed, 21 Aug 2019 16:24:21 GMT https://community.esri.com/t5/arcgis-survey123-questions/max-calculate-on-4-integer-fields-not-returning/m-p/775422#M4840 DougBrowning 2019-08-21T16:24:21Z