Question
After changing the decimal number to string in Tableau Desktop/Prep, the number of decimal places is very large for some numbers.
For example, the String type number shows [.99999999999999999994] or [.0000000000000001] as a string.
Last Modified Date: 15 Feb 2024
Environment
- Tableau Desktop
- Tableau Prep Builder
Answer
Please use the calculation below to set the number of decimals in a String type.STR(INT([Value])) + "." + RIGHT(STR([Value]*100),2)Please change the numbers in the last lines to set the number of decimals. e.g. for 3 numbers, please use [RIGHT(STR([Value]*1000),3)].
The results are as follows.
Please also check the attached workbook for details.
Additional Information
Please check the [Additional Information] part in the below document to see why the number of decimals is changing after being a String Type.Adjustment of Number Format Appears to Round Numbers Incorrectly
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials