The sign of the values in a single row or multiple rows can be inverted/toggled.

Select row(s), then select Insert -> +/- Invert.

Sign of the selected rows are now inverted

Related Links

Display Settings - Numbers

Edit Cell

Utilities

Advanced settings for the invert sign can be done as follows

1. Select Home→ Display (Settings icon) from the Actions section

   

2. Select the Numbers & Inputs tab in the side panel that appears.

   

   Sign in headers

3. Enable Influence Total for the inverted sign to impact the subtotal and total.

   <aside> 💡 Influence Total is visible only after applying an invert sign

   </aside>

4. Enable Sign in headers to display the sign of the row in the category label.

   Once the Sign In header is enabled it opens the below options

   1. Show positive sign: shows positive sign before the header
   2. Show equal on total: Adds equal to sign before the category

   

   Sign in Category labels

<aside> 💡 Note: 1. The invert sign can be applied only to the last node of a hierarchy. ****2. ****The signage of the inserted rows cannot be changed.

</aside>