Fixed Decimal not rounding up - My solution

[Number4]

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

[ChrisTX]

Rounding can definitely be challenging.  See if any of these other posts help:

Rounding problems

the rounding tool doesn't seem to be rounding in the conventional way

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Rounding-problems/td-p/486194

Rounding Down to first Decimal

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Rounding-Down-to-first-Decimal/td-p/24...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/numbers-outputting-quot-3-7E-11-quot-a...

odd behavior of Round function

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Formula-Round-4-975-0-01-getting-4-97-...

Chris