Precision Loss Redshift Data Flow
I am encountering a weird behaviour on using SQL SUM method on decimal values with DOMO Data Flow.
Expected result based on query from MySql:
Result in DOMO after Redshift Data Flow completes:
Issue is that precision is lost in this case and final result will be different in doing SUM on this values:
MySql => 100
DOMO => 99.99.
What can I do in this case to fix that part and to obtain same result as MySql?
Comments

Hi @user037867
You could utilize a ROUND(number, <decimal places>) function in a mysql dataflow to force it to do the rounding to the precision you want instead of having to truncate your numbers on input. If the percentage is calculated in your initial query you can use ROUND there instead of a MySQL data flow as well.
The other option if you must use magic ETL would be to use a calculator tile to multiply your percentage by 100 (shifting the decimal point over 2, use 1000 for 3 decimals of precision etc), set the data type to be a whole number (forces rounding) > set the data type back to decimal > calculator to divide by your original number (100 / 1000 etc).
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 
if possible, i would recommend against intentionally rounding metrics in ETL, keep the data as raw/accurate as possible.
Also, try downloading a sample of your data, the UI sometimes hides the precision of the data.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 
If you are using Redshift, I was able to fix this using "::decimal(16,8)" the first number is the precision and the second one is the scale or how many numbers right of the decimal.
0
Categories
 All Categories
 1.4K Product Ideas
 1.4K Ideas Exchange
 1.4K Connect
 1.2K Connectors
 284 Workbench
 4 Cloud Amplifier
 4 Federated
 2.9K Transform
 88 SQL DataFlows
 553 Datasets
 2.2K Magic ETL
 3.3K Visualize
 2.3K Charting
 558 Beast Mode
 7 App Studio
 27 Variables
 574 Automate
 138 Apps
 413 APIs & Domo Developer
 22 Workflows
 1 DomoAI
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 349 Distribute
 89 Domo Everywhere
 258 Scheduled Reports
 2 Software Integrations
 90 Manage
 87 Governance & Security
 9 Product Release Questions
 Community Forums
 41 Getting Started
 27 Community Member Introductions
 85 Community Announcements
 4.8K Archive