In my app, users trigger a lot of calculations, and I’ve noticed that sometimes the results are saved with the decimal and thousand separators in the wrong place. This leads to inaccurate values being stored in the database.
Important note: I’m not using the “format as” operation anywhere in these calculations - just plain numeric operations.
Hey @gescoapp10 
Welcome to the Bubble Community! 
Which country are you in? By default, Bubble uses decimal points and thousands separators in this format: $8,915,000.50. Since Bubble is based in New York, it follows U.S. formatting conventions.
Does that help? 
If you are storing the data as a “number” type, then there are no thousand separators stored in the db. The issue is likely in how it is displayed. When you display the number on the UI, use the “:Format as number” option. This lets you choose which separators/decimal signs to use.
If you are referring to the Data tab in the editor, that will visualize the numbers using the US options even though the raw data isn’t stored that way. So the year “2025” will appear as “2,025” in the Data tab even though it’s saved as “2025”. Hope that makes sense.
I have the same kind of issue:
1,3 = 1,3
1,34 = 1,34
1,345= 1345,0
So it depends on the number of decimals how the API is handling the number and save it to the db..
Round to 2 is not working.
How to solve this? Thanks for all the help!
This topic was automatically closed after 14 days. New replies are no longer allowed.
