Select to view content in your preferred language

ArcGIS Online Experience Builder Table number decimal places

2654
10
03-30-2023 12:14 AM
Labels (1)
LIEPAJABUILDINGBOARD
Emerging Contributor

Hello!

I have created ExperienceBuilder app with table widget displaying field of numbers with decimal places. In the webmap I have configured decimal places up to two digits, but in the ExperienceBuilkder Table it displays many decimal places. It appears not to all othe entries but to several of them. As these are money amounts, the more than two decimal places look weird. Where should it be configured to display certain amount of decimal places? Below are examples (screenshots) showing decimal places of the same entry. 

 

Screenshot No. 1: Experience Builder Table widget number decimal places extended

Lidzfin_decim.jpg

 

Screenshot No. 2: WebMap pop-up of the same element number field

Lidzfin_decim_pop_up.jpg

10 Replies
AndreasHall
Esri Regular Contributor

I found a related community post where the answer is that removing thousands separator and other settings are on the road map. Hopefully the product development team pick up your request as well!

How to remove comma separator in Experience Builde... - Esri Community

There is also a bug documented: BUG-000152331: The thousand separators are not honored by the Table.. (esri.com). You could try to reach out to technical support in your country and report this as a bug.

TomKukitz
Deactivated User

How is this fix coming along? I have Manholes with slopes in EB looking like this: 1.02365897458295%

This is inexcusable! My Director asked me to fix this and I said I can't Esri has to fix it. He made the comment of for how much we pay for this GIS system something like this should not be an issue!

LindsaySpencer-Henderson
New Contributor

Hi @AndreasHall - will this be addressed with the next update? If anyone has found a work-around, please advise, thanks!

AndreasHall
Esri Regular Contributor

Sorry, I do not have any insights in the development of Experience Builder. I am not on that team.

0 Kudos
NIC
by
New Contributor

Any updates on this issue? I'd really prefer not to have to shorten 60+ fields on a live layer.

AndrewWelsh
Emerging Contributor

Has this been issue been resolved? I am currently having the same issue as those in the chain above with multiple decimal places in the table hosted feature layer I am using in my experience app. I have not as yet found a solution to this in AGOL or Experience Builder? Any updates from ESRI would be much appreciated.

AndrewWelsh
Emerging Contributor

Update on my last message - I found if you are publishing an excel file to AGOL as a hosted feature layer for use as a table in experience builder, you can set the data type to double as you are preparing the layer for publishing. I had it on single data type initially and got heaps of decimal places turn up when I used in experience builder. But setting the type as double, the table displays exactly as I have set it up in the excel file (in this case 1 dp). Hope this helps!

0 Kudos
eleanor_ME
New Contributor

Currently dealing with the same issue. Are there any updates or workarounds on this? 

0 Kudos
AdamsCheyenne
New Contributor

I am also dealing with the same issue. Unfortunately, I'm displaying data from a Chart Statistics Output View (generated in a Chart Widget in the same app) in the Table Widget, so I have no option to edit the decimal places in the source data outside of Experience Builder. It displays acreage as 5.37392027759302773674 acres which is absurd and does not look professional at all. 

0 Kudos