AnsweredAssumed Answered

Performing mathematical operations with Dynamic Text Elements in ArcGIS Pro

Question asked by rohit.mendadhala_tfsgis on Jun 4, 2019

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 "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 be slight tradeoffs 1 more or less), which is the reason I am trying to add the TFS and FD dynamic text elements. 

 

Is there a way to do this either through Pro or Python?

Outcomes