KNOWLEDGE BASE

Display Small Negative Values Using Round Brackets


Published: 23 Jul 2020
Last Modified Date: 27 Jul 2020

Question

How to format a number field so that small negative values that have all digits showing as zero appear in parentheses (round brackets)

Environment

  • Tableau Desktop

Answer

Specify a custom number format.

For example, to format a number field to 3 decimal places so that small negative values that have all digits showing as zero appear in round brackets, specify the custom format as: 0.000;(0.000);(0.000)
Did this article resolve the issue?