topic Re: Dynamic Content Rounding in ArcGIS Experience Builder Questions

Dynamic Content Rounding

Anonymous User — Thu, 28 Jan 2021 02:44:54 GMT

I'm using a text widget in Experience Builder and added a dynamic value. The value in one case is -0.276. I want to convert this to a percentage which typically entails multiplying it by 100. The result becomes -27.63384185.

Can I round this to 1 decimal place in the expression box? The Round function (thinking Arcade and Python) doesn't work. I'm presuming the only functions that work are the ones listed in the tool (Average, count, sum, min, max). How does one control the appearance of numbers in a calculation?

Thanks

Brian

Re: Dynamic Content Rounding

JonathanMcDougall — Tue, 09 Mar 2021 23:34:52 GMT

@Anonymous User I'm looking for the very same answer - having 8 decimal places in a return in far from ideal.

Re: Dynamic Content Rounding

JacobRothberger — Fri, 16 Jul 2021 17:47:29 GMT

@Anonymous User - Did you ever find a solution to this issue?

Re: Dynamic Content Rounding

MontyBell — Thu, 29 Jul 2021 00:21:41 GMT

We are also encountering this problem. Would like to use ROUND, FLOOR, or CEIL on a number. These are Arcade Expressions, but Dynamic Text doesn't like them.

Re: Dynamic Content Rounding

DavidRasner1 — Sun, 01 Aug 2021 19:10:43 GMT

Oh man, I got into an awkward conversion about this during a meeting. People are looking at my dashboard and first thing they ask... why so many decimals? 😐 Yes, so... I don't actually know. Why?

I haven't found a way to do this.

Re: Dynamic Content Rounding

LuukvanGorp — Fri, 13 Aug 2021 14:41:47 GMT

Hi Brian, I find this problem very relatable. Currently it makes no sense to use the expressions from the Dynamic Content because the rounding is visually unpleasing. Now all rounding up and downs have to be done in preparation. Although it works, it seems a waste to have the expressions exist if you cannot round up or down.

I hope something like this will be implemented soon!

Re: Dynamic Content Rounding

JayJohnsonWashoeCounty — Tue, 17 Aug 2021 21:25:19 GMT

We need ROUNDING in ExpBuilder.

Soooo frustrating...

Re: Dynamic Content Rounding

Jianxia — Fri, 19 Nov 2021 04:28:30 GMT

Thank you all for raising the issue. We are currently working on it, and plan to address it in the near future. Thank you for being patient with us.

Re: Dynamic Content Rounding

NatalieKraft — Mon, 14 Feb 2022 21:07:46 GMT

Hi Jianxia!

I'm excited to hear that this is of interest to ESRI! Is there any update on when the issue will be fixed? In the meantime, do you suggest any workarounds?

Natalie

NC State University

Re: Dynamic Content Rounding

Jianxia — Tue, 15 Feb 2022 21:13:39 GMT

@NatalieKraft , you should be able to format numbers in the upcoming March update. Unfortunately I am not aware of any straightforward workarounds at this point.

Re: Dynamic Content Rounding

ANesdoly — Mon, 21 Mar 2022 18:20:26 GMT

Has the rounding of dynamic text been implemented and updated yet? If so how can I use this feature?

Re: Dynamic Content Rounding

Jianxia — Tue, 22 Mar 2022 06:03:20 GMT

@ANesdoly not yet. The March update is planned to be out this Wednesday PST.

Re: Dynamic Content Rounding

MichaelGaiggEsri — Wed, 18 May 2022 18:37:03 GMT

Rounding is available in Experience Builder:

- connect your element (e.g. text) to data

- select the element, click the database icon to specify dynamic content and select "Expression" tab

- in the bottom left corner there is a gear icon that opens the "Number formatting" window, toggle it on and specify decimal places, to show thousands separator, and display unit

- select attribute and click insert button

Re: Dynamic Content Rounding

GiulioMol — Mon, 08 Aug 2022 15:54:05 GMT

I think this method is only for customizing use, not for use on portal

Re: Dynamic Content Rounding

Jianxia — Mon, 08 Aug 2022 23:20:03 GMT

This capability is in ArcGIS Enterprise 11.0, released in July 2022.

Re: Dynamic Content Rounding

WhitneyPatterson — Fri, 06 Oct 2023 18:27:29 GMT

@Jianxia - any update on being able to round dynamic content in text widgets in Experience Builder? Or any formatting of dynamic content? (IE being able to display the value of $145,321 as $145.3K). Our EXBs look very messy.

Re: Dynamic Content Rounding

GISAdmin39 — Fri, 10 Nov 2023 15:30:12 GMT

I'd love to be able to do this with statistics. I've got a chart widget that shows the sum of a category by percent, and it gives me percent to 3 decimal places, which overlaps other values.

Re: Dynamic Content Rounding

BRogers92 — Fri, 09 Feb 2024 14:42:11 GMT

What @MichaelGaiggEsri mentioned in his post in the most up-to-date way that I found. It is a little janky at times, but works as intended.

Re: Dynamic Content Rounding

jerome6 — Mon, 30 Sep 2024 20:50:18 GMT

I don't see the gear icon at the bottom of the Expression tab. Am I using an older version of EB?

Re: Dynamic Content Rounding

AlderMaps — Wed, 29 Jan 2025 23:04:55 GMT

Thank you! Stumbling around in AGOL today and couldn't find it for myself 😅