0

In the below screen shot I have built a report using a matrix. I have a working expression that changes the color of the columns "Avg Wait AD" and Avg Wait Other". I use static numbers to identify the ranges for the colors. Now I need a expression that can change the color of the "Consolidated" row. The consolidated column is just a Total row (Or a calculated row) that I've added. The problem I'm having is that in each day, I can have between 1-3 items (Consolidated is not considered an item). I'm stuggling with getting the amount of items there are in the day so I can use that in my calculation. My expression would look something like

=IIF(Sum(Fields!Avg_Wait_Time___AD.Value) >= (CurrentItemsInDay * 60), "Red", IIF(Fields!Avg_Wait_Time___AD.Value < (CurrentItemsInDay * 60) AND Fields!Avg_Wait_Time___AD.Value >= (CurrentItemsInDay * 28), "Orange", "Green"))

(I'm just using CurrentItemsInDay for illustration purposes)

enter image description here

HiTech
  • 913
  • 1
  • 16
  • 34
  • I assume you have made a group and then set a total after each group. Select the gray tab next to the row you want the font to have a different colour and add your expression to the Color property. – Snowlockk Jun 13 '17 at 14:39
  • @Snowlockk I know how to change the font color just fine. I need to know how to get the count of items in the group (Day) so I can use that in my expression. – HiTech Jun 13 '17 at 14:46
  • Possibly this https://stackoverflow.com/questions/16320495/total-row-count-for-grouped-values-in-ssrs-2008? – Snowlockk Jun 13 '17 at 14:50
  • Using CountRows() was the key. I was looking at https://stackoverflow.com/questions/12505651/ssrs-report-builder-3-0-row-grouped-records-count as you posted your comment. – HiTech Jun 13 '17 at 15:20
  • Possible duplicate of [SSRS Report Builder 3.0 Row Grouped records count](https://stackoverflow.com/questions/12505651/ssrs-report-builder-3-0-row-grouped-records-count) – Pants Jun 13 '17 at 17:57

0 Answers0