4 Replies Latest reply on Aug 22, 2016 5:08 AM by harris.tsr

# Prevent rounding numbers in \$K

Hi Everyone,

Came across with an odd situation. I use some amounts from a spreadhseet for example:  Amount X = 4700, divided by 1000 to show it as 4.7 (because the header indicates \$K) then, I divide this amount by a coefficient i.e. 50 and then, I need to times this amount x100.

For example: ((4700/100)/50)*100 = 9.4. This 9.4 is what I want to display in the dashboard, but instead, Tableau rounds it down to 9. I have checked the number format both automatic an custom and doesn't seem that something needs to be changed. I don't want to set the units in K, because I indicate the \$K in the header.

The cells format that contain the numbers in the spreadhseet is "General" but there is a reason for that as well, so it would be good to remain General

Is there any ideas how to show the reuslt of the calculation in the view I described?

Many thanks

• ###### 1. Re: Prevent rounding numbers in \$K

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

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

Hey Harris,

Make sure that when you format the number that you pay close attention to the following:

Make sure that the correct measure is selected.

If the correct measure is selected, choose for the right option Axis/Pane

The next step is the formatting itself !

Hope this helps.

Regards,

Matthias

• ###### 4. Re: Prevent rounding numbers in \$K

Thank you everyone for your responses, they were very helpful. I managed to display the accurate value using the ROUND function.

Many thanks