Framed Sum in Rank & Window Magic ETL not treating zeroes properly
Hi there,
I'm trying to produce a rolling 12 month total for each month in a dataset, but I'm finding with some of the partitions that I get a negative exponential when I'm expecting it to return zero (all the months are zero  see raw data screenshot). It doesn't seem to happen with every partition that has zero values, so I'm not sure what's going wrong. Has anyone had this issue before?
Thanks, Mike
Best Answer

Using your screen shots I built a webform and tested this out and I got the same results. I added in an "Alter Columns" tile and CAST the "Total Revenue" column to be a Fixed Decimal and after that the Rank & Window returned 0.0 on the rows I expected to be 0.
I can't remember exactly why this happens but it is something to do with binary and scientific notation not playing well together.
1
Answers

Using your screen shots I built a webform and tested this out and I got the same results. I added in an "Alter Columns" tile and CAST the "Total Revenue" column to be a Fixed Decimal and after that the Rank & Window returned 0.0 on the rows I expected to be 0.
I can't remember exactly why this happens but it is something to do with binary and scientific notation not playing well together.
1 
@TheLookout Tried it out and it worked perfectly! Thanks so much for your help :)
1
Categories
 All Categories
 1.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 292 Workbench
 4 Cloud Amplifier
 8 Federated
 2.8K Transform
 95 SQL DataFlows
 600 Datasets
 2.1K Magic ETL
 3.7K Visualize
 2.4K Charting
 685 Beast Mode
 43 App Studio
 38 Variables
 656 Automate
 170 Apps
 439 APIs & Domo Developer
 42 Workflows
 5 DomoAI
 32 Predict
 12 Jupyter Workspaces
 20 R & Python Tiles
 384 Distribute
 110 Domo Everywhere
 268 Scheduled Reports
 6 Software Integrations
 111 Manage
 108 Governance & Security
 8 Domo University
 25 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 98 Community Announcements
 Domo Community Gallery
 4.8K Archive