Tableau Prep Builder Does Not Preview Relevant Rows When Selecting A Value With Infinite Decimals

Published: 31 Jul 2020
Last Modified Date: 25 May 2021


When selecting a value of a measure containing many repeated decimals in Tableau Prep Builder step UI, the results preview does not render.


  • Tableau Prep Builder


This behavior is by design. To work around this behavior, we can take a two-step approach:
  1. In a new Clean step, create one calculated field for each of the affected fields with the formula: ROUND([Affected Field Name], 14)
  2. In a subsequent second new Clean step, remove the original affected fields so only the rounded fields remain


Tableau Prep was designed to round infinite floating point number results to 14 places.
Did this article resolve the issue?