
1. Re: Rounding Decimals
Jim Dehner Jan 3, 2018 12:34 PM (in response to TaRan Wilson)Hi
did you try a round function Round(value,2) for 2 decimal places?
Jim


3. Re: Rounding Decimals
Jeff Strauss Jan 3, 2018 12:37 PM (in response to Jeff Strauss)oh, of course, Jim Dehner is more accurate if you're looking for the round function. Sorry, I may have misread it.


5. Re: Rounding Decimals
TaRan Wilson Jan 3, 2018 12:48 PM (in response to Jim Dehner)Jim, I'm not very good with calculations. How and where would I add Round function to convert my onscreen values?
@Jeff/Arvindgarg  Thanks for the replies, but I am wanting to round the nearest two decimal places, not simply show only two decimal places (it's currently displaying that way).

6. Re: Rounding Decimals
Todd Storm Jan 3, 2018 12:53 PM (in response to TaRan Wilson)Tableau is already rounding the value to the nearest hundredth, .0017 rounds down to .00; it would need to be at least .005 to round up to .01.

7. Re: Rounding Decimals
TaRan Wilson Jan 3, 2018 1:17 PM (in response to Todd Storm)Yes, I suppose that's accurate. l was thinking that if it was at 0%, it shouldn't show, but I guess it will, since it technically meets the criteria for display. Thanks for pointing that out Todd.