We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and
join in on the fun here.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
If you're trying to turn the quotient into a string with two characters after the decimal but without rounding, you can use tostring(22.33/2) then use a RegEx tool's Parse output method and use this formula: (\d+\.\d{2})
This is pretty strange behaviour, definitely won't be trusting this function for rounding in the future:
As you can see above, the function rounds 0.155 downwards to 0.15, but rounds 0.165 upwards to 0.17.
It isn't consistent with which hundredths it rounds up or down, as 11.165 is rounded down.
The solution is to use the Round function before wrapping in the ToString function, like I have in the 'Round first' field in the picture. Use a formula like this:
ToString(round([Number],0.01))
