
1. Re: Understanding how Round() function handles 5's
Sasha Hanna Nov 7, 2018 9:22 AM (in response to David Marquardt)2 of 2 people found this helpfulHi David,
I recommend using the number format and reduce the number of decimal places, which will give you the conventional rounding.
Let me know if this helps.
Cheers,
Sasha

2. Re: Understanding how Round() function handles 5's
Mavis Liu Nov 7, 2018 9:43 AM (in response to David Marquardt)1 of 1 people found this helpfulHi David,
When you use the round function it will round to the nearest decimal place that you specify.
Maybe try aggregating the field inside the calculation :
round(SUM([Value]),1)
Try the above and let me know whether that works.
Thanks,
Mavis

3. Re: Understanding how Round() function handles 5's
David Marquardt Nov 7, 2018 11:49 AM (in response to Sasha Hanna)Sasha,
Thank you! I can use this for some of my projects. It's a bit of a hack, still, and isn't quite as explicit to viewers about what's going on, but it will work  thanks!
I am wondering the formula and reasoning behind making Rounding the way Tableau does, though. I wonder why they didn't use traditional Rounding as a calculation?
David

4. Re: Understanding how Round() function handles 5's
David Marquardt Nov 7, 2018 12:19 PM (in response to Mavis Liu)Mavis,
Yes! this is a very helpful response. Thank you! Do you have an explanation as to why this works, and what the original ROUND calculation is meant to do?
David

5. Re: Understanding how Round() function handles 5's
David Marquardt Nov 9, 2018 7:11 AM (in response to David Marquardt)Thanks for all the advice! I was wanting to understand the ROUND function because I need to create a calculation with conditional formatting (multiple decimal place formats for one measure). Mavis provided a way to get most of my scripts to work, but I am curious what is the rational behind the ROUND function, and why Tableau doesn't include the conventional rounding method in their calculations.
David

6. Re: Understanding how Round() function handles 5's
Mavis Liu Nov 9, 2018 2:11 PM (in response to David Marquardt)Hi David,
It looks like Tableau may use something called Bankers Rounding? 
ROUND function argument not working
Unexpected Results: Rounding  Drawing with Numbers
Thanks,
Mavis