topic Re: how to round labels in Data Management Questions

how to round labels

STEVEHIRSCH — Mon, 09 Oct 2017 16:30:55 GMT

I have three fields that I am trying to label and one that I am trying to round to the nearest whole number. Here is what I have so far:

"Pipe ID: " + [ID_PIPE] & vbNewLine & [DIAM_INCH] + " in." & vbNewLine & Round ( [LENGTH_FT] ) + " ft."

I keep getting an error that says:

Error 1 on line 2.

Type mismatch: 'esri_2'.

I'm pretty sure it is related to the Round ( [LENGTH_FT] ) but I don't know what I'm doing wrong...

Thanks!

Re: how to round labels

DanPatterson_Retired — Mon, 09 Oct 2017 19:01:55 GMT

a type mismatch suggests that your Length_feet is a string and not an integer. Check to see if it is and cast it to a float before rounding

Re: how to round labels

XanderBakker — Mon, 09 Oct 2017 20:42:52 GMT

You shouldn't be using the "+" in VBA to combine text, only use "&" for this. Also I am not sure if you have to specify the number of decimals when rounding a value. Try this:

"Pipe ID: " & [ID_PIPE] & vbNewLine & [DIAM_INCH] & " in." & vbNewLine & Round([LENGTH_FT], 0) & " ft."‍‍

Re: how to round labels

TedKowal — Tue, 10 Oct 2017 15:20:59 GMT

Alternatively:

"Pipe ID: " & [ID_PIPE] & vbNewLine & [DIAM_INCH] & " in." & vbNewLine & CInt([LENGTH_FT]) & " ft."

I believe if using the field calculator it only accepts Vbscript which is not as rich in functions as VBA or VB ... The CInt will perform the .5 or higher rounding automatically.

Re: how to round labels

XanderBakker — Tue, 10 Oct 2017 15:44:18 GMT

True Ted Kowal it is VBScript and not VBA. However, Round Function is supported and should be used if you want for instance a single decimal. In ArcMap you can use Python, VBScript and JScript

In ArcGIS Pro you would probably want to use ArcGIS Arcade | ArcGIS for Developers , since that seems to be the future:

"Pipe ID: " + $feature.ID_PIPE + "\n" + $feature.DIAM_INCH + " in." + "\n" + Round($feature.LENGTH_FT, 0) + " ft."‍

Re: how to round labels

DanPatterson_Retired — Tue, 10 Oct 2017 18:21:09 GMT

Grief... I hope not

Re: how to round labels

TedKowal — Wed, 11 Oct 2017 15:47:01 GMT

I am an old time VB'r Round function was not initially part of vbscript got added later on! I am a dinosaur too and have used the CINT function for quick rounding for many years In any event... I am pretty much switched over script wise to python now; application wise I am still using vb.net or until they take that away too!

Re: how to round labels

XanderBakker — Wed, 11 Oct 2017 15:55:33 GMT

Hi Dan Patterson , actually it is the way is going and although in some cases it might require some adaption, there are some nice things it offers. See below a document I published this week with some examples:

Create pop-ups in ArcGIS Online with conditional images using Arcade

And in version 10.6, ArcGIS Pro 2.1, there will be something new called Attribute Rules which is based on Arcade too (initially designed as functionality for the ArcGIS Utility Network Management Extension, but it will be a feature available throughout the platform).

Re: how to round labels

XanderBakker — Wed, 11 Oct 2017 16:04:07 GMT

Hi Ted Kowal , I think it is a good thing that you switched to Python for scripting.I did that a number of years ago and I'm glad I did.

Using VB.Net and ArcObjects is something which is not too future proof. It might be time to switch over to Pro and explore the possibilities. There is a webinar tomorrow that might be interesting (Building ArcGIS Pro Add-Ins and Solution Configurations):

https://www.esri.com/training/catalog/59b1d6e447f0252a6fc5a48c/building-arcgis-pro-add-ins-and-solution-configurations/

Re: how to round labels

DanPatterson_Retired — Wed, 11 Oct 2017 23:42:36 GMT

Nice Xander... the declarative 'vars' and extra curly braces are reminiscent of those languages I have abandoned or chosen to avoid , but should I need to label anything, I will have your link on hand.

Re: how to round labels

TedKowal — Thu, 12 Oct 2017 14:52:47 GMT

I have yet to make Pro work for me... I spend more time trying to figure out why it crashes on me! So atm I have put it aside till there is more stability. I will keep your thoughts in mind and look at the webinar. Thanks