Last Modified Date: 08 Jul 2017
- Create a calculated field that finds the last digit of the number. For example:
FLOAT(RIGHT(STR([Amount]),1)). In this case 1.2 will return a value of 2.
- Create an IF statement that uses this amount, and then adds the number necessary to round up to the next whole number:
If [Last Digit In Field] > 0 Then [Amount] + ((1 - [Last Digit In Field]*.1)) Else [Amount] End
Additional InformationTableau 10.3 also has CEILING() and FLOOR() functions that can solve this type of calculations without needing to do string conversions.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials