Monday, 17 July 2017

Negative Number Representation in Reports

Hi There,

Just want to share with you short tip: if you want to have a different representations of negative numbers in the report, it is easy to do using format file in control properties.

So if you have negative numbers with "-" sign, like here:

You can change format in control Properties.

For that example, if you want to show it in brackets (1) instead of -1, than just use following mask:
 #,##0.00;(#,##0.00)
As you can see here, negative representation is specified after ";" sign.
Masks are related to standard .NET formatting rules.

And than you can check it in browser.


Have a fast reporting!

3 comments:

Saiful Murad said...

Hi Sergey,

How about showing negative numbers in red color?

Sergey Marenich said...

Hi Saiful,
Please check S130 training guide: https://openuni.acumatica.com/courses/reporting/s130-inquiries-reports-and-dashboards/
Lesson 9: Using Alternative Colors in Report Data

Saiful Murad said...

Thank you so much!