5 Replies Latest reply on Nov 9, 2018 2:11 PM by Mavis Liu

    Understanding how Round() function handles 5's

    David Marquardt

      Hello,

       

      I'm trying to figure out how to best use the round function, especially since a lot of my data uses decimals that end in 5.   I read about banker's rounding (number round either up or down to the nearest even integer, if I understand correctly).  But I can't make sense of what I'm getting when I use the round function - I'm guessing it's rounding to the nearest odd number?   Am I using the ROUND function incorrectly?   Can someone confirm this, and if so, why doesn't tableau say this in their function explanation?

       

      I'm attatching a Tableau file as well with the function....