This content has been marked as final.
Show 4 replies
-
1. Re: Prevent rounding numbers in $K
Steve Taylor Aug 19, 2016 3:18 AM (in response to harris.tsr)Hello Harris
Have you tried the ROUND() function in tableau? If you want to fix the number to 1 decimal place write something like ROUND(<your calc>, 1)
Sorry if you've already tried that, it's the first thing i'd use.
Steve
-
2. Re: Prevent rounding numbers in $K
Steve Taylor Aug 19, 2016 3:46 AM (in response to harris.tsr)Hello again
An alternative option to using the Round function would be to follow the steps in this workbook attached. You can format the axis and Pane for a measure differently as shown in this example where the axis has $K and the pane has your single decimal place (based on the calculation you mentioned).
Steve
-
3. Re: Prevent rounding numbers in $K
Matthias Goossens Aug 19, 2016 6:10 AM (in response to harris.tsr) -
4. Re: Prevent rounding numbers in $K
harris.tsr Aug 22, 2016 5:08 AM (in response to harris.tsr)Thank you everyone for your responses, they were very helpful. I managed to display the accurate value using the ROUND function.
Many thanks