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.5K Product Ideas
 1.5K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 283 Workbench
 4 Cloud Amplifier
 4 Federated
 2.7K Transform
 90 SQL DataFlows
 566 Datasets
 2K Magic ETL
 3.4K Visualize
 2.3K Charting
 596 Beast Mode
 14 App Studio
 29 Variables
 595 Automate
 149 Apps
 417 APIs & Domo Developer
 28 Workflows
 1 DomoAI
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 362 Distribute
 99 Domo Everywhere
 261 Scheduled Reports
 2 Software Integrations
 97 Manage
 94 Governance & Security
 14 Product Releases
 Community Forums
 37 Getting Started
 28 Community Member Introductions
 90 Community Announcements
 4.8K Archive