Loading

How to Round Up Numbers At Decimal Points in Tableau Desktop

Publiceringsdatum: Apr 13, 2024
Uppgift
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
Steg
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:

  • User-added image

The results are as follows, please check the attached workbook for details:


User-added image
Ytterligare resurser
The existing CEILING function Rounds Up the numbers only to an integer and there is no option to specify the decimal points.

See also How to Round Down Numbers At Decimal Points in Tableau Desktop

 
Knowledge-artikelnummer

001458391

 
Laddar
Salesforce Help | Article