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

Question

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!

EvanGPetrie · Answer

@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)

EmilyGeo · Answer

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.

EllieHakariAK · Answer

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. 😊