Both variables are number inputs that get populated from a button trigger. Whenever the trigger is executed, the number value spits out more significant figures than it has been set to. Both Quality Index (Lower & Upper Limits) variables have been set to Decimal setting '1.00" for 2 significant fi…

Hey @gentleboyjones - The widget property for precision just adjusts how values are presented within the app editor, but doesn’t actually impact how that data is stored in the table itself. So regardless of that setting, all numbers are stored to ~9 decimals. The tables UI shows all numbers to 3 de…

Thanks, Pete. I’ll keep that in the back of my mind. (y).

Hi Pete, working on splitting device output data text string into the test value and Unit of Measure, then storing the numerical test value as a number, but TEXTTONUMBER is dropping the trailing zeros which are (potentially) significant digits. Any suggestions?

@jmlowden , good question. Try appending the ROUND() function before TEXTTONUMBER() for the number if 0s you need. If it still drops the 0s let me know and I can do some sleuthing to see if there’s a trick.

Also seeing that when I write the numerical data variable to a table, it is only saving three decimal places… [image] UPDATE: which I realize Pete explained above, just missed it first pass - the csv download has the same digits as what I am able to see in Player, but still dropping the terminal …

I added the ROUND() function a suggested and even tried adding +1 to the second term in the function, but the output remains the same. [image]

@jmlowden , I checked in with our product team on this. This is a known gap, and we have several projects in motion to address this. No hard delivery date right now but it is something we’re aware of and working on.

Do you know if any progress was made on this feature?

Hi @landers - Welcome to Tulip Community! :tada: I am checking in on this with the Tulip Product team, and will follow up next week. Have a good weekend :slight_smile:

Calculation Significant Figures

Support, Troubleshooting, & Help

OlgaStroilova January 29, 2025, 5:21pm 16

Hi @jmlowden and others - great news, we’re planning a release to support storing trailing zeros:

Topic		Replies	Views
Upcoming Release: Numbers Precision Announcements feature-request , number-precision	23	615	March 7, 2025
Decimal Place Formatting Issue Support, Troubleshooting, & Help	2	196	January 29, 2025
Treatment of Decimals / Precision of Numbers Product Suggestions	9	534	December 6, 2024
Functions Number Format - Trailing Zeroes General	0	47	December 4, 2025
Significant Figure Control on Variables and Widgets Product Suggestions number-precision	2	90	January 9, 2025

Calculation Significant Figures

Related topics