Dynamic Content Rounding

1626
12
01-27-2021 06:44 PM
Brian_Kaplan
Occasional Contributor

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

Tags (2)
12 Replies
JonathanMcDougall
Occasional Contributor III

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

JacobRothberger
New Contributor II

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

 

MontyBell
New Contributor II

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. 

DavidRasner1
New Contributor III

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.

LuukvanGorp
New Contributor

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!

JayJohnsonWashoeCounty
Regular Contributor

 We need ROUNDING in ExpBuilder.  

Soooo frustrating...

Jay
Washoe County GIS
Jianxia
Esri Regular Contributor

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.

NatalieKraft
New Contributor

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

0 Kudos
Jianxia
Esri Regular Contributor

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