topic Re: Unable to use Field Calculator with "SHAPE__Length" as an expression variable in Data Management Questions

Unable to use Field Calculator with "SHAPE__Length" as an expression variable

JoshMakesMaps — Tue, 04 Jan 2022 00:01:10 GMT

I'm trying to multiply "SHAPE__Length" by another numeric field, "width". Both fields are type double.
When doing this in Portal, I don't receive any errors. It just doesn't calculate. It will calculate other values and fields, as long as it's not using "SHAPE__Length".
When attempting this in Pro, I get the generic ERROR 999999 fail code.

I have a workaround in Pro:
With Calculate Geometry, set target field = length.
With Field Calculator, set the same target field = (target field * width field)

I would still like to know what I'm doing wrong with the original workflow.

Re: Unable to use Field Calculator with "SHAPE__Length" as an expression variable

DanPatterson — Tue, 04 Jan 2022 03:59:12 GMT

Check your table for the correct field name it appears that you have 2 _ (underscores ) in the name and usually it appears like

Shape_length

Re: Unable to use Field Calculator with "SHAPE__Length" as an expression variable

JoshMakesMaps — Tue, 04 Jan 2022 19:30:11 GMT

@DanPatterson, This is how the field name is generated for online content, with two underscores. When creating the layer in AGO/Portal, or even uploading a layer from Pro.

Re: Unable to use Field Calculator with "SHAPE__Length" as an expression variable

JoshMakesMaps — Tue, 04 Jan 2022 19:36:56 GMT

I was able to successfully perform this task using AGO content. It seems to be a bug/limitation with Portal content.

Re: Unable to use Field Calculator with "SHAPE__Length" as an expression variable

JoshMakesMaps — Thu, 13 Jan 2022 23:14:30 GMT

IT figured out a fix. Use this in place of "SHAPE__Length" for any (Arcade) calculation:(Number($feature.SHAPE__Length)