SSRS Switch Colour Expression multiple groups criteria

Question

I trying to colour code a group within a group based on a value.

enter image description here

I am quite new to SSRS, and have tried various expressions, SWITCH, IIF etc but I cant seem to get them to reference the various criteria and groups correctly.

Answer 1

You've not explained what your criteria is so this is just a guess. I'm also assuming that the Target values are numeric, so 5 and not 5 days for example.

I'm also assuming that you want the background to be green is the count of DAYS2 >= Target

If this is the case then you can do something simple like this

=IIF(COUNT(Fields!DAYS2.Value) < Fields!Target.Value, "Green", "Red")