To round to exactly two decimals the first thought is to use ROUND or FLOOR. Right? However, Tableau rounds numbers based on the original value in the database, following...
Add a unique and sequential ID to a data set with Tableau Prep Builder with two possible calculations.
How to deduplicate records (rows) in data sets with Tableau Prep Builder using one of two methods. The classic Aggregate vs ROW_NUMBER.
This article illustrates the risk of data redundancy and how to resolve it using Tableau Prep and create an insightful Vizualisation or Dashboard