Skip to main content
Solved

Changing color for negative numbers in Report Designer


I currently have a report that looks like this:

How can I get the negative dollar values to appear in red?

 

I have searched other solutions. The closest option I have found is overlapping fields and using VisibleExpr. The issue comes in the fact that, the dollar value column uses an if-statement to calculate its value as a negative. So, I’m not able to tie the VisibleExpr field to a specific parameter like [ARInvoice.DocType] etc.

 

Here is a screenshot of the if-statement used:

Is there a way to have the VisibleExpr calculate based on the end result of the “Value” field?

 

Thank you,

Best answer by mhayes1987

Thanks, Daryl. 

I’m not sure if this is exactly what you meant, but your suggestion did help me get to this answer. 

 

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

5 replies

darylbowman
Captain II
Forum|alt.badge.img+13

I think you can base it on whether the DocType is 'CRM' since that's what's setting the value to be negative (unless there are also negative values in addition to that).


  • Author
  • Freshman II
  • 3 replies
  • November 22, 2024

Hi Daryl,

Unfortunately not all line items on the credit memos are always negatives. If you notice the last credit in my screenshot CM018220 - there is a positive line item on that credit (it’s only a credit memo because the full total of the memo is negative). So, in those situations I would not want the number highlighted red, since this report is broken down by the individual line items.

Likewise, there are also sometimes negative line items on invoices - they are just an invoice memo because the full total is positive.


darylbowman
Captain II
Forum|alt.badge.img+13

In that case, you should be able to test if the entire 'if' statement is less than zero:

=IIf(...)<0

And 

=IIf(...)>=0


  • Author
  • Freshman II
  • 3 replies
  • Answer
  • November 22, 2024

Thanks, Daryl. 

I’m not sure if this is exactly what you meant, but your suggestion did help me get to this answer. 

 


darylbowman
Captain II
Forum|alt.badge.img+13

Not quite what I meant, but it should work.


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