Showing negative number as positive but also making sure the Total Row is summing correctly

I have pivot table that looks something like this: Cost of Sales Others & Expenses are negative so that the Subtotal & Total are calculated correctly.
I know you can show the negative either in red (with a minus sign in front) or in financial style. But is there anyway to get rid of the positive sign but still making sure that the Subtotal and Total rows are correct?
Comments
-
Because how Domo processes the data with the Pivot table you can't have your data elements display positive but your total negative and vice versa. I'd recommend logging an idea in the idea exchange to allow for this.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
You could use the "financial style negatives (100)" option, which is a standard way to deal with this, and uses parentheses instead of negative signs:
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 306 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 787 Beast Mode
- 78 App Studio
- 43 Variables
- 742 Automate
- 187 Apps
- 474 APIs & Domo Developer
- 67 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive