Summing data and applying parenthesis to negative value.
I need to sum 3 pieced of data, subtract a value and then show the value in a parenthesis for any that equal a negative value.
I have seen a post about this formula, but how do I use this with the the other sum function:
=VALUE(MID(ColumnName@row, 2, 10))
My formula:
=SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row
Thanks Kristi
Best Answer

Lets try wrapping the math part in the middle of the text string in parenthesis so that it calculates before converting to a text string.
=IF(SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row>= 0, SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row, "(" + (SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row) + ")")
Answers

I was given this formula by a coworker but is not working either.
=IF(LEFT(Number2, 1) = "", "(" + ABS(Number2) + ")", Number2)

Try this:
=IF(SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row>= 0, SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row, "(" + SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row + ")")

I am getting unparsable. It is like there is a missing parenthesis somewhere in there. Trying to figure it out

I don't see any out of place or missing parenthesis. Double check that I spelled your column names correctly.
Are you able to provide a snippet of the formula in the sheet similar to the snippet below?

This calculation for 2023 In Year will be a negative value. The team wants it to show in parenthesis like normal accounting formats in excel here.

What about the formula you said was giving you the error? That one should be working for you.

Here are the errors I am getting and the formula used. #INVALID OPERATION

Lets try wrapping the math part in the middle of the text string in parenthesis so that it calculates before converting to a text string.
=IF(SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row>= 0, SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row, "(" + (SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row) + ")")

Any way to incorporate a thousands comma in here should the numbers be that large? i.e., $2,000 displayed as ($2,000) rather than ($2000).
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!