KNOWLEDGE BASE

## How to Round Up Numbers At Decimal Points in Tableau Desktop

Published: 04 Feb 2022

### Question

How can I display the numbers rounded up after a certain decimal point?
When the result of multiplication results in a decimal point, how to display it by truncating.

Example:
\$3456.15  → 3457  OR  \$3456.15  → 3456.2
\$3456.87  → 3457  OR  \$3456.87  → 3456.9

### Environment

• Tableau Desktop

Create the following calculations to round up the numbers after a certain decimal point in Tableau Desktop.

Without Parameter (Not able to specify the decimal point):
• Round up to the whole number: CEILING(SUM([Quantity]))
• Round up with decimal point: CEILING(SUM([Quantity (copy)])*10)/10
With Parameter (Able to specify the decimal point):
• CEILING(SUM([Quantity])*[Number])/*[Number]
• The parameter setting is as follows:
• The results are as follows, please check the attached workbook for details:
{"ft_lang_label":"__label__en","ft_lang_prob":0.6988629,"math_prob":0.95794433,"size":257,"snap":"2022-27-2022-33","text_gpt3_token_len":79,"char_repetition_ratio":0.15019763,"word_repetition_ratio":0.0,"special_character_ratio":0.4007782,"punctuation_ratio":0.17857143,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.98009384,"pos_list":[0,1,2,3,4],"im_url_duplicate_count":[null,null,null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2022-08-10T08:15:15Z\",\"WARC-Record-ID\":\"<urn:uuid:32f7ebc3-addb-447d-a20c-5c26f9ac2409>\",\"Content-Length\":\"105008\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:bd252f8e-71ba-4281-9ad5-7ad4596c159a>\",\"WARC-Concurrent-To\":\"<urn:uuid:43c6f614-e0d2-4d34-835d-c2d2cc508f64>\",\"WARC-IP-Address\":\"13.110.24.16\",\"WARC-Target-URI\":\"https://kb.tableau.com/articles/howto/how-to-round-up-numbers-at-decimal-points-in-tableau-desktop\",\"WARC-Payload-Digest\":\"sha1:BNWI3RGMCUHIN4ZWVTCHU4ZYJL5DTPW7\",\"WARC-Block-Digest\":\"sha1:YMG34DUQXITMZIQ2OEY5WYGB7V4POXZI\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2022/CC-MAIN-2022-33/CC-MAIN-2022-33_segments_1659882571150.88_warc_CC-MAIN-20220810070501-20220810100501-00019.warc.gz\"}"}