topic Performing mathematical operations with Dynamic Text Elements in ArcGIS Pro in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/performing-mathematical-operations-with-dynamic/m-p/379356#M16691 <HTML><HEAD></HEAD><BODY><P>I have a map that has two layers (TFS_ALL and FD_ALL) which actually feeds the data from two tables in SQL server. There is also a third table called (ALL_ALL) which has the combined (UNION_ALL) information of TFS_ALL and FD_ALL from the SQL server. I am trying to use a Dynamic text for printing the sum of all the values in the field&nbsp;"acres" of these two layers (TFS_ALL, FD_ALL) and round them. Now when I use a third dynamic text element to print the sum of acres of TFS_ALL and FD_ALL, I am unable to find any dynamic text functionality for adding two dynamic text strings which are actually numbers. I even tried to add them using ArcPy module in python, but that didn't work either. Please find below screenshots related to it. How do I add up 9 and 11 below to get 20? Both 9 and 11 are dynamic text elements and they change based on the data that feeds from SQL server. I obtained 16 by using dynamic text count (since it is irrespective of rounding )from SQL table (ALL_ALL) but if I use sum there will be rounding issues and they might not always add up to give the exact correct number (there may&nbsp;be slight tradeoffs 1 more or less), which is the reason I am trying to add the TFS and FD dynamic text elements.&nbsp;</P><P></P><P>Is there a way to do this either through Pro or Python?</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/449605_pastedImage_1.png" /></P></BODY></HTML> Tue, 04 Jun 2019 15:33:02 GMT RVG296 2019-06-04T15:33:02Z Performing mathematical operations with Dynamic Text Elements in ArcGIS Pro https://community.esri.com/t5/arcgis-pro-questions/performing-mathematical-operations-with-dynamic/m-p/379356#M16691 <HTML><HEAD></HEAD><BODY><P>I have a map that has two layers (TFS_ALL and FD_ALL) which actually feeds the data from two tables in SQL server. There is also a third table called (ALL_ALL) which has the combined (UNION_ALL) information of TFS_ALL and FD_ALL from the SQL server. I am trying to use a Dynamic text for printing the sum of all the values in the field&nbsp;"acres" of these two layers (TFS_ALL, FD_ALL) and round them. Now when I use a third dynamic text element to print the sum of acres of TFS_ALL and FD_ALL, I am unable to find any dynamic text functionality for adding two dynamic text strings which are actually numbers. I even tried to add them using ArcPy module in python, but that didn't work either. Please find below screenshots related to it. How do I add up 9 and 11 below to get 20? Both 9 and 11 are dynamic text elements and they change based on the data that feeds from SQL server. I obtained 16 by using dynamic text count (since it is irrespective of rounding )from SQL table (ALL_ALL) but if I use sum there will be rounding issues and they might not always add up to give the exact correct number (there may&nbsp;be slight tradeoffs 1 more or less), which is the reason I am trying to add the TFS and FD dynamic text elements.&nbsp;</P><P></P><P>Is there a way to do this either through Pro or Python?</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/449605_pastedImage_1.png" /></P></BODY></HTML> Tue, 04 Jun 2019 15:33:02 GMT https://community.esri.com/t5/arcgis-pro-questions/performing-mathematical-operations-with-dynamic/m-p/379356#M16691 RVG296 2019-06-04T15:33:02Z Re: Performing mathematical operations with Dynamic Text Elements in ArcGIS Pro https://community.esri.com/t5/arcgis-pro-questions/performing-mathematical-operations-with-dynamic/m-p/379357#M16692 <HTML><HEAD></HEAD><BODY><P>&nbsp;I have a similar question, but related to simple text formatting. For example, the Dynamic text item for a map center, when given the unit value 'mgrs' and round of 0 returns '60HXD' (i.e. the UTM zone and grid square) as its smallest value. I want to take that value and just display, for example, the first 3 characters (i.e. 60H) or the last 2 (i.e. XD).</P><P>It doesn't appear that you can assign the value of a dynamic string and then modify it?</P></BODY></HTML> Tue, 22 Oct 2019 21:18:58 GMT https://community.esri.com/t5/arcgis-pro-questions/performing-mathematical-operations-with-dynamic/m-p/379357#M16692 GeoNZ 2019-10-22T21:18:58Z