Rounding Discrepancies

[aaronindm]

I am seeing some strange results when rounding - see attached workflow.

You can see that Alteryx is storing some inexact (and slightly less) version of those numbers.  When I attempt to round those numbers to the 0.01 spot, I get unexpected results.

Does anyone have an explanation and/or foolproof method to deal with this issue?

Orig Entered        Expected       Alteryx

1.255                    1.26              1.25

4.255                    4.26              4.26    (only correct one)

2.005                    2.01              2.00

2.255                    2.26              2.25

[jdminton]

I wanted to share the post with my solution to this rounding issue: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Macro-for-rounding-Hint-Altery...