Skip to main content

In a report I want to highlight/ change the background color if the value is greater than 1. I understand i need to put two fields on top of one another. One with the default state and one with the changed state. my questions are as follows:

=[POLine.BaseOpenQty]

=[POLine.BaseOpenQty]               

Do I use visible expressions for each field? Can you help me write the expression?

I am leaning towards an IIF, but that is as far as i got.

Hi @richard77  Long back I also worked on the similar kind of requirement. Please find the details below and hope this helps!!

  • As you said, we need to have two fields. One for Color one and other one is default field.
  • For the Colored one, you can provide the Background color
  • Yes, we need to provide the Visible expression for the 2 fields like below

Visible Expression for Backgroud Colored Field =>  rPOLine.BaseOpenQty] > 1

Visible Expression for Non - Backgroud Colored Field =>  sPOLine.BaseOpenQty] <= 1

Attached screenshots for your reference.

Colored Field

 

 

 

@Naveen B Thank you that worked great.

@richard77 Most welcome. Thanks for the update. :)

@Naveen Boga  Hello Captain， you are extremely smart.  This helped a lot. Thank you.

Hi, @ray20  Hope you are doing well!

I’m glad that I helped you! :) 

Reply


Terms & ConditionsCookie settings