Skip to main content
Answer

Negative amounts on ARM report

  • April 8, 2023
  • 4 replies
  • 393 views
J
Freshman I

 

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

4 replies

J
Freshman I
  • jameswong
  • Author
  • Freshman I
  • April 8, 2023

Sorry… We want brackets. :-)

Laura03
Captain II
Forum|alt.badge.img+19
  • Laura03
  • Captain II
  • 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?

~ Laura Barber, WM Synergy
Doug Johnson
Chris Hackett
S
Semi-Pro III
Forum|alt.badge.img+9
  • sweta68
  • Semi-Pro III
  • 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

Doug Johnson
Chris Hackett
J
Freshman I
  • jameswong
  • Author
  • Freshman I
  • 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.  

Laura03
Chris Hackett
S
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved