I've read a few threads on this and didn't come across any reasonable answers. The one that did have an answer, required 4 additional formulas in one tool.
To me, this is just clunky and makes others scoff at Alteryx in my department.
Thought I'd create a post vs. responding to the older ones.
Please comment if you've since found a different way as well.
I almost always use Fixed Decimal for my values. This issue of rounding (as I am using Alteryx to transform a process from Excel to Alteryx) is generating a massive exception report with a $0.01 variance on each of the items.
I found what appears to be a simple solution to this issue. Instead of using "Fixed Decimal", use the default "Double." Then in the formula, use the Round function. Round([FIELD],.01).
You can later change this to "Fixed Decimal" if need be, using the "Select" tool.
Other Posts:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Decimal-not-rounding-up/td-p/483096
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-Odd-Behavior/td-p/89086
