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.1K Product Ideas
 1.1K Ideas Exchange
 1.2K Connect
 969 Connectors
 256 Workbench
 Cloud Amplifier
 1 Federated
 2.4K Transform
 76 SQL DataFlows
 500 Datasets
 1.8K Magic ETL
 2.7K Visualize
 2.2K Charting
 373 Beast Mode
 20 Variables
 484 Automate
 102 Apps
 378 APIs & Domo Developer
 6 Workflows
 22 Predict
 6 Jupyter Workspaces
 16 R & Python Tiles
 316 Distribute
 64 Domo Everywhere
 252 Scheduled Reports
 59 Manage
 59 Governance & Security
 1 Product Release Questions
 5K Community Forums
 37 Getting Started
 23 Community Member Introductions
 63 Community Announcements
 4.8K Archive