nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcade expression round decimal to zero decimal places

AndrewL

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

Find more posts tagged with

Accepted answers

XanderBakker

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

All comments

WillAnderson

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.

YanisleyGuilarte

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

XanderBakker

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 ("#")

DataOfficer

Ah got it, thanks.

XanderBakker

Hi @DataOfficer ,

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

DataOfficer

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:

AndrewL

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

XanderBakker

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

AndrewL

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.

XanderBakker

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.