How do I resolve warning 002858?

2667
2
07-28-2020 11:58 AM
KatieMichel
New Contributor

Hi, I'm trying to find the percent change of temperature using two climate projections with the formula %change=((new-old)/old)*100. When running it through "calculate field" this is what I have:

and I get this warning message with all of my values returned as null:

Any ideas? 

0 Kudos
2 Replies
DanPatterson
MVP Esteemed Contributor

It is a warning... one of your two fields has a null value in it, so when it tries to perform the numerator operation, it is either getting

a number - None

or

None - a number

So you will have to fix your data if you aren't expecting nulls in those fields, or you will have to fix the expression to deal with nulls.

In any event, a warning probably didn't make all the calculations fail did it?


... sort of retired...
0 Kudos
IssamAchour
New Contributor

yeah how to perform calculations and you have NULL values? i have these kinds of data since this information aren't reported so it must be involved in my geoprocessing work

 how to deal with that using python?

0 Kudos