By using this website, you agree to our Terms of Use (click here)
Hi Everyone,
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?
Hi Beaker,
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
#,##0.00;(#,##0.00)
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!
How do you get this to work on rows that have a different format? I have some rows with $ signs and those values show up with a minus sign. I tried the above on the row set but this error
