Skip to main content
Solved

Negative amounts on ARM report


 

We created a ARM report for our Inc Statement.  We have some value that are negative that we would like to show with brackets instead of a minus sign.  Most of the rows are set to show the value and they have brackets but we have a few rows that we have $ signs that show up with a minus sign.  We want minus signs 

This is the formatting formula we’ve used

I tried updating with the following

 =’$###,###,###.00’; ‘($###,###,###.00)”

but I get this error

Am I using the wrong format formula?

Best answer by sweta68

Hi @jameswong ,

  • Could you please try to change Format under Appearance section in Properties tab as below.
'$#,##0.00;($#,##0.00)'

Hope, it helps!

Regards,

Sweta

View original
Did this topic help you find an answer to your question?

4 replies

  • Author
  • Freshman I
  • 4 replies
  • April 8, 2023

Sorry… We want brackets. :-)


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3033 replies
  • April 9, 2023

Hello, in your formula, I see a combination of single and double quotes. I think all quotes should be single  in the example. Could the quotes be causing the error?


Forum|alt.badge.img+10
  • Semi-Pro III
  • 229 replies
  • Answer
  • April 10, 2023

Hi @jameswong ,

  • Could you please try to change Format under Appearance section in Properties tab as below.
'$#,##0.00;($#,##0.00)'

Hope, it helps!

Regards,

Sweta


  • Author
  • Freshman I
  • 4 replies
  • April 10, 2023

Thanks for the replies.  We got it to work.  Laura, I think that was a typo on my part.  Sweta, this is what we ultimately came up with.  


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings