In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Displaying Negative Numbers in Parentheses
I have a Profit & Loss report that I designed with the Acumatica Analytical Report Manager (Financial Report Writer)
The negative values appear with a negative sign in front of them like this:
But I'd like them to appear with parentheses around them.
Does anyone know if it's possible to have the numbers display with parentheses around them rather than the negative sign in front?
Probably the best place to control the formatting in this case is in the Column Set.
If you put the following in the Column Set
Like is pictured here:
Then the negative numbers should display as with parentheses around them like is pictured here:
Acumatica Version 6.10.0472 used when composing this response
Interesting. So it seems that what comes after the semicolon is the format that you want for negative numbers.
Very cool. It works!