fetch only first 2 decimals without rounding the numbers

0 votes
Fetch/show the 2 digits after decimal point without rounding off numbers.
May 8 in Tableau by geetha
9 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
Hi Geetha,

You can convert the decimal number into a string and then fetch the left n characters.

you can write code as LEFT(STR([number]),n).

The created field is added as a dimension, later convert into number by changing the data type.

Hope it helps you.
answered May 8 by CHERUKURI
• 13,940 points

Related Questions In Tableau

0 votes
1 answer

Divide count of Table 1 by count of Table 2 on the same time interval

Use a custom SQL to create a ...READ MORE

answered Apr 11, 2018 in Tableau by QueenBee
• 1,810 points
13 views
0 votes
1 answer

Apply filters only on the dashboard

First of all why??? Second of all, it ...READ MORE

answered Apr 13, 2018 in Tableau by QueenBee
• 1,810 points
13 views
0 votes
1 answer
0 votes
1 answer

How to fetch the previous value in a column or row?

Hi Sindhu, You can use LOOKUP() or PREVIOUS_VALUE() in ...READ MORE

answered 5 days ago in Tableau by CHERUKURI
• 13,940 points
9 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
948 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
36 views
+2 votes
1 answer
0 votes
1 answer

How to get only the last n months action of all my records?

Hi Nithin, You can use Calculated field to ...READ MORE

answered Mar 8 in Tableau by CHERUKURI
• 13,940 points
31 views
0 votes
1 answer

How to show a chart with only a part of the dimension/measure value.

Hi Nithin, Follow below steps: 1. Create a calculative ...READ MORE

answered Apr 2 in Tableau by CHERUKURI
• 13,940 points
9 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.