Hi, I have always assumed that the null values, -666666666 etc. were of course not valid data. However, I always assume that a 0 is an actual 0. For example ( https://data.census.gov/table/ACSST5Y2023.S1701?q=S1701&g=1400000US06001400100&moe=false ) has a fair number of zero values. Can I safely assume that generally (there might always be some exceptions) that I can trust a zero is a zero? I am looking at tract level for this example and at lower levels there will be real gaps.
Any help is appreciated, thanks.
Tom
OK, I figured it out (at least in my example) the percent is always accurate as its null when the number of people is zero and therefore the percent should be null not 0% which is what would be expected.