Floating integers / Floating decimals, rounding
How does DOMO's version of MySQL handle floating integers when rounding?
I went to round a field in my Dataflow. So that I could avoid changing 50 cards and removing the decimals in this feild.
Round(`Trans`,0)
When aggregated in the card I am showing my total trans is far lower than it should be. opposed to a bit higher after the rounding.
Comments
-
Hi,
May be you can lock your datatype in workbench or can use ROUND function to get the desired output.
You can try below option in ETL or beast mode as well :
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"Thanks,
Neeti
0 -
What do you mean by floating integers? Typically when talking about data types floats and integers are two very different data types with floats (DECIMALS in Domo) containing a decimal point and integers do not.
Is it just a matter that youre data is represented as a float with numbers always followed by .0? Do you have sample data?
Typically if you're doing rounding and the numbers are off means the roudning is causing the data to be off.
For example if you have the following data points: 1.4, 1.4, 1.4 Roudning the numbers before the sum would cause them all to be 1 for a total of 3 but when you add them all together it'd equal 4.2 (rounded after the sum would be 4) causing different resulting numbers.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive