topic Re: How can I remove decimal points when summing records in the cluster labelling textbox? in ArcGIS Online Questions

How can I remove decimal points when summing records in the cluster labelling textbox?

EllieHakariAK — Tue, 31 Oct 2023 19:13:59 GMT

Hello!

I am currently attempting to create dynamic labels for my clusters in Map Viewer. As you can see below, I am using SUM to get a total for Filled and Vacant positions within each cluster.

However, the total is being followed by two decimal places (.00). Is there a way to remove these?

Thank you for your assistance!

Re: How can I remove decimal points when summing records in the cluster labelling textbox?

gis_KIWI4 — Tue, 31 Oct 2023 21:45:39 GMT

Hi @EllieHakariAK ,

I believe you cannot use the round function within the Text pop-up.
You could try using the Arcade pop-up if you want to use expressions like round, etc.

For what you are trying to achieve, I believe there might be a simple fix.
Use the "Fields" tab to select the attribute you want to remove the decimals from and set the significant digits to '0 Decimal places'

Hope this helps 🙂

Re: How can I remove decimal points when summing records in the cluster labelling textbox?

EllieHakariAK — Tue, 31 Oct 2023 22:18:19 GMT

Hi @gis_KIWI4, thanks for the reply!

That was my first thought, but the field I am summing is a text field (it says either "Filled" or "Vacant") so there is no option to change the decimals to zero. Looking at other forum posts, it seems like this may be one of those things that doesn't have a solution at the moment, but I thought I'd make my own post anyways.

Thank you again for your response, I appreciate it. 😊

Re: How can I remove decimal points when summing records in the cluster labelling textbox?

EmilyGeo — Tue, 31 Oct 2023 23:04:30 GMT

Hi @EllieHakariAK,

I think you're close. Is {SUM_Vacant} an arcade expression that you are pulling into the pop-up? If so, you can add the Round function to that expression inside the arcade editor to display it as a rounded value in the pop-up.

Re: How can I remove decimal points when summing records in the cluster labelling textbox?

EvanGPetrie — Mon, 09 Sep 2024 19:50:39 GMT

@EllieHakariAK

I know this is nearly a year later, but I was also looking into a work around for this and found the same answer as @EmilyGeo.

Under Options there is the Attribute Expressions tab.

Yours should look like:

Round(Sum($feature.SUM_Vacant),0)