In ThoughtSpot, you have the option to display negative metrics/measures in three different formats. This option can be enabled from the number formatting options, primarily used to display negative values in brackets.
To enable this option when creating a new answer from the table format:
Here is a screenshot illustrating this process: