×

Data

Advance with Assist shares quick solutions to common challenges encountered by the InterWorks Assist on-demand team.

Question: I’m trying to remove the decimal from my report, but I’m getting unexpected results. With FLOOR or ROUND on my calculation, I still have a decimal. How can I remove it without formatting in the format menu all the time?

Questions like this happen to all of us. You expect a certain result, but what you get is unexpected. You may go through your standard checklist of options to make sure you haven’t formatted something incorrectly, or in a different way on a different sheet, but in this case, you are creating a new calculation. The function should work, right?

Here, we look at the definitions of the functions and determine that ROUND and FLOOR should give us what is needed. So why doesn’t it work?

ROUND Function

This function rounds numbers to a specified number of digits. The decimals argument specifies how many decimal points of precision to include in the final result. If decimals is omitted, number is rounded to the nearest integer.

FLOOR Function

This function rounds a number to the nearest integer of equal or lesser value. It’s supported in the following sources as of October 2018:

• ExcelText File
• Statistical File
• Tableau Server
• Datastax, Google BQ and Analytics
• Salesforce
• Spark SQL

The key is in compatibility with the data source. In this case, our client was using a function that wasn’t supported by their data source, so the only option is to use formatting in the view or default properties. Before you bang your head against a wall, make sure you understand what your data source will allow you to do. Tableau allows you to work in all kinds of data quickly, but not all data sources have every function.

KeepWatch by InterWorks

Whether you need support for one platform or many, our technical experts have you covered.

Dustin Wyers

How Assist by InterWorks Supports Your Entire Data Stack Assist by InterWorks has been helping hundreds of InterWorks clients for years now. Assist got its beginnings as an on-demand, Tableau ...
Tableau Conference 2021: Devs on Stage in Review As always, the keynotes from the Tableau Conference, even virtually, are always an exciting highlight, and I love getting to write ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×