I am currently going through Chapter 7 of Getting to Know ArcGIS Pro called Geoenabling Your Project. I am in part A on step 9. I have taken the following steps: Open the community housing project Add the table for household_income Join the household_income table to the la_census_tracts Open fields view and create a new field for AMI (Area median income) as a double, numeric, 2 decimal places Attempt to calculate field for AMI using HHIncome (household_income) Here is where I am stuck. The instructions say to enter ! household_income.csv.HHIncome! / 56241 * 100 When I click run it takes about 6.5 minutes. I receive an error message a few minutes in which says: Warning 002858: Certain rows set to NULL due to error while evaluating python expression: TypeError: unsupported operand type(s) for /: 'NoneType' and 'Int' Looking at the AMI column, the entire thing reads <null> I have tried entering others values for it to evaluate, such as setting them all to 6. It eventually failed with an error saying "Something unexpected cause the tool to fail." and "General function failure" while still filling in most of the values to 6, but leaving some at the end of the table as <null> I also tried using the python box but I am not familiar enough with the software to get much out of that. I also looked at the data in the household_income file and found that several HHIncome read as " - " in the excel sheet which translated into ArcGIS Pro as <null> . I am not sure if this has to do with the problem. Others I know have used the same file and not had this problem. Thanks in advance for any advice!
... View more