Forum Discussion

JDIreland's avatar
JDIreland
New Member
4 years ago
Solved

Report Builder - Expression for background colors assistance

Hi there,   I am building a table report in Report Builder. The report has 3 colour ranges for Red, Amber and Green. Red is values equal to or more than 7 Green is qual to or less than 4 Amber i...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Have you tried nesting like this?

    IIF(Me.Value <= 4, "Green", IIF(Me.Value >= 7, "Red", "Orange"))

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Have you tried nesting like this?

IIF(Me.Value <= 4, "Green", IIF(Me.Value >= 7, "Red", "Orange"))

 

88Bronco2's avatar
88Bronco2
New Member
2 years ago

Hello, I am guessing you can figure this out, what is the syntax for two conditions?  This is what I tried and its not working for me:

 

IIF(Fields!PHYCAP.Value >= 250 & Fields!SUM_INA_AVAIL_.Value >= 500, "Aqua",IIF(Fields!PHYCAP.Value >= 101 & Fields!PHYCAP.Value <= 249 & Fields!SUM_INA_AVAIL_.Value >= 250, "Aqua",IIF(Fields!PHYCAP.Value < 100 & Fields!SUM_INA_AVAIL_.Value >= 50, "Aqua","White")))

 

I very much appreciate any help you can provide!

  • 88Bronco2's avatar
    88Bronco2
    New Member
    2 years ago

    FIXED IT:

    =IIF(Fields!PHYCAP.Value >= 250 AND Fields!SUM_INA_AVAIL_.Value >= 500, "Aqua", IIF(Fields!PHYCAP.Value >= 101 AND Fields!PHYCAP.Value <= 249 AND Fields!SUM_INA_AVAIL_.Value >= 250, "Aqua", IIF(Fields!PHYCAP.Value < 100 AND Fields!SUM_INA_AVAIL_.Value >= 50, "Aqua", "White")))