Issue rounding numbers in a textfield

Avatar

Avatar

meem23

Avatar

meem23

meem23

04-10-2020

Hi,  

I have text fields that are populated from XML data.  The data can be text or numeric, so I have a script in the initialized event to display a pattern if the data is a number:

this.format.picture.value = "num{zz9.9999%}";

Some of the numbers do not round correctly and this is causing manual editing which is a lot of work as I have to proof 250+ fields.  The point of automating these fields is to save time and effort.  Is there a solution to my problem?  I have found a few posts, but those solutions are not working for my situation - or at least I can't get it to work.

An example is a value of 0.0046875 and it should display as 0.4688%.  Instead it is displaying as 0.4687%.

View Entire Topic

Avatar

Avatar

meem23

Avatar

meem23

meem23

12-10-2020

OMG - thank you soooo much - it works!