topic Re: Calculate Field tool in ArcGIS Pro Questions

Calculate Field tool

KateEkhator74 — Mon, 01 Nov 2021 23:04:40 GMT

Hello

Am trying to calculate the percentage area of the land cover classes in my map and keep on getting this error message (see attached). I tried changing the setting when adding the new field (percentage) so that I can click on the allow null, but it is greyed out. I tried clicking on the error message and it tells me there is no solution at this time.

Please can anyone help?

Thanks.

Re: Calculate Field tool

DanPatterson — Mon, 01 Nov 2021 23:10:24 GMT

Do you have any records with null values in that field?

I would add a new field (eg double, Area2, make sure it isn't nullable)

Then try the expression again.

Re: Calculate Field tool

JayantaPoddar — Mon, 01 Nov 2021 23:31:20 GMT

Could you delete the comma in the denominator (15675.2), and try again?

Re: Calculate Field tool

DanPatterson — Mon, 01 Nov 2021 23:55:50 GMT

comma could be localization

Re: Calculate Field tool

KateEkhator74 — Tue, 02 Nov 2021 01:45:39 GMT

The percentage field had zeros (0) after I added the field (see attached), made sure data type was double. I can't edit the column for null when adding field. It opens greyed out.

Re: Calculate Field tool

KateEkhator74 — Tue, 02 Nov 2021 01:48:47 GMT

Thanks, removed comma and it worked.

Re: Calculate Field tool

KateEkhator74 — Tue, 02 Nov 2021 01:49:24 GMT

This worked, thanks.