This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Off the top of my head, I've run into some strange math behavior in Alteryx when I unknowingly had NULLs in my data.
So the first thing I would do is use a formula tool on Amount that says
(**shout out to @MarqueeCrew as it's been years since I used that formula).
The other thing that occurred to me is that "Amount" really isn't a whole number even though it looks like one (and if there were decimals, they should be displayed), but @LordNeilLord's suggestion will handle that issue.
I tried Floor(Amount) and that didn't work. There are also no nulls in my data
I tried changing [Amount] from Double to Fixed Decimal and that does work.
Anyway, I have a attached workflow with data for one period.
The background (not included in workflow) is that I have used the Batch Input Macro to get 3 cells from 36 workbooks and then output that to a yxdb file. The attached is the same data, i just filtered the yxdb down to one period.