topic Re: Arcade expression round decimal to zero decimal places in ArcGIS Online Developers Questions

Arcade expression round decimal to zero decimal places

AndrewL — Thu, 10 Jan 2019 21:33:31 GMT

I have the following Arcade expression. However, it does not round to the nearest whole number. It always produces a number with two decimal places. Not sure if I am doing something wrong? Thanks.

var grid = $feature.GRIDCODE*10
var roundedValue = Round(grid, 0)
roundedValue

Re: Arcade expression round decimal to zero decimal places

XanderBakker — Fri, 11 Jan 2019 12:33:11 GMT

I guess all your values show two decimal zeros in the pop-up, right? If this is a value that is shown in the attribute table, remember that with the configure attributes of the pop-up you define the number of decimals to be used. Since the Round function returns a value, you still have to provide the correct format (0 decimals) in the attribute configuration in the pop-up.

Re: Arcade expression round decimal to zero decimal places

AndrewL — Fri, 11 Jan 2019 15:17:11 GMT

Yes that's correct values show two decimal zeros in the pop-up.

In the configure attributes I do have zero decimal places selected:

In the actual db the GRIDCODE field is a double.

Re: Arcade expression round decimal to zero decimal places

XanderBakker — Fri, 11 Jan 2019 15:48:09 GMT

It's not the input attribute that requires formatting but the expression (sorry for the Spanish screenshot, but you get the idea):

Re: Arcade expression round decimal to zero decimal places

AndrewL — Fri, 11 Jan 2019 15:52:45 GMT

Oh I see it now. Thanks! Yes that worked.

Re: Arcade expression round decimal to zero decimal places

XanderBakker — Fri, 11 Jan 2019 15:57:08 GMT

Glad it works!

Re: Arcade expression round decimal to zero decimal places

DataOfficer — Tue, 26 Oct 2021 17:13:09 GMT

Hi @XanderBakker , I am doing something similar but using the expression in a custom attribute display, and therefore do not have the option to round the result afterwards.

The expression is as follows:

// call the sites feature layer
var sites = FeatureSetById($map, /* Sites */ "Test_site_layer_8539")

// establish spatial relationship between the two layers and return a count
var grids = Count(Intersects($feature, sites))

// round the result

var roundgrids = Round(grids, 0)
return roundgrids

The test shows the number formatted correctly, but in the popups it still shows 2 decimal places. This is how the popup is formatted:

Re: Arcade expression round decimal to zero decimal places

XanderBakker — Tue, 26 Oct 2021 17:17:23 GMT

Hi @DataOfficer ,

The same applies. In the list of fields you will need to specify the decimals for the (virtual) field "expression/expr2".

Re: Arcade expression round decimal to zero decimal places

DataOfficer — Wed, 27 Oct 2021 08:21:28 GMT

Ah got it, thanks.

Re: Arcade expression round decimal to zero decimal places

XanderBakker — Wed, 27 Oct 2021 12:49:35 GMT

Hi @DataOfficer ,

To avoid having to enter the list of fields and define how many decimals should be used you can use the Text function and format it the way you want. Have a look at the example below:

var x1 = PI * 100; Console(x1); var x2 = Round(x1, 3); Console(x2); var x3 = Text(x2, "#.00"); Console(x3); var x4 = Text(x2, "#"); Console(x4);

This will write to the console:

314.1592653589793 314.159 314.16 314

Contains the original value (PI * 100)
The result of rounding it to 3 decimals (it is still a number)
Converting to a text indicating to format it using always ("0") 2 decimals (even when 0)
Converting to a text using no decimals and eliminating leading/trailing zeros ("#")

Re: Arcade expression round decimal to zero decimal places

DataOfficer — Wed, 27 Oct 2021 13:24:14 GMT

Excellent thank you. I appreciate your continued advice on this forum.

Re: Arcade expression round decimal to zero decimal places

YanisleyGuilarte — Thu, 08 Jun 2023 12:31:26 GMT

I have the same problem.

What I did was I create a new field (Double) field calculate all for my (Short )field. In ArcGISPro.

In Web Map: I went to pop up and put "0 decimal Places". and resolve.

SO the field has to be DOUBLE

Re: Arcade expression round decimal to zero decimal places

WillAnderson — Thu, 10 Aug 2023 23:26:13 GMT

Xander,

Is there a way to use Arcade to limit which number values show trailing zeros? For example, I want to use a number attribute for labelling. Some numbers have decimals values (e.g. 110.5), but must are whole numbers. Is there an Arcade expression I can use so we only see decimal values for values with decimals NOT zero (e.g. see values as 1, 2, 3, not 1.0, 2.0, 3.0)? I also want to avoid seeing zeros after decimals in popups.