https://community.esri.com/t5/data-management-questions/dividing-does-not-work/m-p/1402036#M45044 <P><A href="https://services.arcgis.com/VTyQ9soqVukalItT/ArcGIS/rest/services/ACS_5YR_ESTIMATES_CHAS_TRACT/FeatureServer/1/query?where=T8_EST95%3E0+AND+T8_EST69%2FT8_EST95%3E1&amp;objectIds=&amp;time=&amp;geometry=&amp;geometryType=esriGeometryEnvelope&amp;inSR=&amp;spatialRel=esriSpatialRelIntersects&amp;resultType=none&amp;distance=0.0&amp;units=esriSRUnit_Meter&amp;relationParam=&amp;returnGeodetic=false&amp;outFields=&amp;returnGeometry=true&amp;returnCentroid=false&amp;returnEnvelope=false&amp;featureEncoding=esriDefault&amp;multipatchOption=xyFootprint&amp;maxAllowableOffset=&amp;geometryPrecision=&amp;outSR=&amp;defaultSR=&amp;datumTransformation=&amp;applyVCSProjection=false&amp;returnIdsOnly=false&amp;returnUniqueIdsOnly=false&amp;returnCountOnly=false&amp;returnExtentOnly=false&amp;returnQueryGeometry=false&amp;returnDistinctValues=false&amp;cacheHint=false&amp;orderByFields=&amp;groupByFieldsForStatistics=&amp;outStatistics=&amp;having=&amp;resultOffset=&amp;resultRecordCount=&amp;returnZ=false&amp;returnM=false&amp;returnExceededLimitFeatures=true&amp;quantizationParameters=&amp;sqlFormat=none&amp;f=html&amp;token=" target="_self">Solved it!</A> We had to check that the denominator is not 0.</P> Thu, 28 Mar 2024 16:15:31 GMT AdrienHaccoun 2024-03-28T16:15:31Z https://community.esri.com/t5/data-management-questions/dividing-does-not-work/m-p/1401736#M45040 <P>Hello,</P><P>I have trouble to make basic mathematical operation in the REST API of ArcGIS.</P><P>I just want to query a division of 2 fields.</P><P>While this operation should work, see <A href="https://services.arcgis.com/VTyQ9soqVukalItT/ArcGIS/rest/services/ACS_5YR_ESTIMATES_CHAS_TRACT/FeatureServer/1/validateSQL?sql=T8_EST69%2FT8_EST95%3E1&amp;sqlType=where&amp;f=pjson&amp;token=" target="_self">here.</A></P><P>When I try to query it, it doesn't. See <A href="https://services.arcgis.com/VTyQ9soqVukalItT/ArcGIS/rest/services/ACS_5YR_ESTIMATES_CHAS_TRACT/FeatureServer/1/query?where=T8_EST69%2FT8_EST95%3E1&amp;objectIds=&amp;time=&amp;geometry=&amp;geometryType=esriGeometryEnvelope&amp;inSR=&amp;spatialRel=esriSpatialRelIntersects&amp;resultType=none&amp;distance=0.0&amp;units=esriSRUnit_Meter&amp;relationParam=&amp;returnGeodetic=false&amp;outFields=&amp;returnGeometry=true&amp;returnCentroid=false&amp;returnEnvelope=false&amp;featureEncoding=esriDefault&amp;multipatchOption=xyFootprint&amp;maxAllowableOffset=&amp;geometryPrecision=&amp;outSR=&amp;defaultSR=&amp;datumTransformation=&amp;applyVCSProjection=false&amp;returnIdsOnly=false&amp;returnUniqueIdsOnly=false&amp;returnCountOnly=false&amp;returnExtentOnly=false&amp;returnQueryGeometry=false&amp;returnDistinctValues=false&amp;cacheHint=false&amp;orderByFields=&amp;groupByFieldsForStatistics=&amp;outStatistics=&amp;having=&amp;resultOffset=&amp;resultRecordCount=&amp;returnZ=false&amp;returnM=false&amp;returnExceededLimitFeatures=true&amp;quantizationParameters=&amp;sqlFormat=none&amp;f=html&amp;token=" target="_self">here.</A></P><P>The addition work well, but not the divisions. Any thoughts on that?</P><P>Thank you for your help!</P> Wed, 27 Mar 2024 22:57:32 GMT https://community.esri.com/t5/data-management-questions/dividing-does-not-work/m-p/1401736#M45040 AdrienHaccoun 2024-03-27T22:57:32Z https://community.esri.com/t5/data-management-questions/dividing-does-not-work/m-p/1401737#M45041 <P>Possibly related:&nbsp;</P><P>BUG-000085841&nbsp;<A href="https://support.esri.com/en-us/bug/the-create-database-view-tool-does-not-accept-the-divid-bug-000085841" target="_self">The Create Database View tool does not accept the divide operator '/' in the view definition input field.</A></P> Wed, 27 Mar 2024 23:03:30 GMT https://community.esri.com/t5/data-management-questions/dividing-does-not-work/m-p/1401737#M45041 Bud 2024-03-27T23:03:30Z https://community.esri.com/t5/data-management-questions/dividing-does-not-work/m-p/1401951#M45043 <P>Hello&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/589140">@AdrienHaccoun</a>&nbsp;, could you Multiply by the Reciprocal (1/x) of the second field value ?</P> Thu, 28 Mar 2024 14:06:48 GMT https://community.esri.com/t5/data-management-questions/dividing-does-not-work/m-p/1401951#M45043 ChrisUnderwood 2024-03-28T14:06:48Z https://community.esri.com/t5/data-management-questions/dividing-does-not-work/m-p/1402036#M45044 <P><A href="https://services.arcgis.com/VTyQ9soqVukalItT/ArcGIS/rest/services/ACS_5YR_ESTIMATES_CHAS_TRACT/FeatureServer/1/query?where=T8_EST95%3E0+AND+T8_EST69%2FT8_EST95%3E1&amp;objectIds=&amp;time=&amp;geometry=&amp;geometryType=esriGeometryEnvelope&amp;inSR=&amp;spatialRel=esriSpatialRelIntersects&amp;resultType=none&amp;distance=0.0&amp;units=esriSRUnit_Meter&amp;relationParam=&amp;returnGeodetic=false&amp;outFields=&amp;returnGeometry=true&amp;returnCentroid=false&amp;returnEnvelope=false&amp;featureEncoding=esriDefault&amp;multipatchOption=xyFootprint&amp;maxAllowableOffset=&amp;geometryPrecision=&amp;outSR=&amp;defaultSR=&amp;datumTransformation=&amp;applyVCSProjection=false&amp;returnIdsOnly=false&amp;returnUniqueIdsOnly=false&amp;returnCountOnly=false&amp;returnExtentOnly=false&amp;returnQueryGeometry=false&amp;returnDistinctValues=false&amp;cacheHint=false&amp;orderByFields=&amp;groupByFieldsForStatistics=&amp;outStatistics=&amp;having=&amp;resultOffset=&amp;resultRecordCount=&amp;returnZ=false&amp;returnM=false&amp;returnExceededLimitFeatures=true&amp;quantizationParameters=&amp;sqlFormat=none&amp;f=html&amp;token=" target="_self">Solved it!</A> We had to check that the denominator is not 0.</P> Thu, 28 Mar 2024 16:15:31 GMT https://community.esri.com/t5/data-management-questions/dividing-does-not-work/m-p/1402036#M45044 AdrienHaccoun 2024-03-28T16:15:31Z