Thank you pointing this option out but I do not believe it will help as it requires a blanket formatting change for the entire Profit column (in your example). My scenario is one that allows negatives in the column (and in group 2) but the normal values of group 2 will be positive and I want to have a formula for the total of (All values in the column in Group 1) - (All values in the column in Group 2) + (All values in the column in Group 3).
The problem with the blanket formatting change is that the normal values of group 3 are generally negative so I do not want to change the formatting for those.
Is there no way to write a basic formula for a total without changing the input that go into that formula?
Following up on this, here is a Tableau example that utilizes what I am saying: https://www.tableau.com/solutions/workbook/cfos-overview-business
The income statement has all positive values listed but if you look closesly Net Sales = Gross Sales - Discounts; Gross Profits = Net Sales - Cogs;
Operating Income = Gross Profits - (each value of Operating Expense) OR Operating Income = Gross Profits - (the sum of all values in Operating Expense) etc....
This appears to be a formula rather than just a grand total summed over the column. In this case, ZZ's suggestion from above could be in play where all negative values are kept as is for mathematical purposes and then the values are summed over the column to reach the correct totals and then all negatives are removed for display purposes. I am not sure which is the case.
My purposes are ever so slightly different as a negative value appearing in the entries has informative value outside of just how it impacts the total.
Ideally, I want to be able to put a formula in for the total where (from my original screenshot):
(sum of all values in Gross Profits, which appear as positives)
- (sum of all values in Operating Expenses, which generally should appear as positives)
+ (sum of all values in Other Income (Expense), which can appear as negative or positive)
ZZ's suggestion would solve the display problem for Operating Expenses but would create a new problem for Other Income (Expenses) section by hiding informative negative values.
Hopefully that clarified the situation a bit more and someone has insight into this.