Post reply

formatting field based on max value

  • March 28, 2017 at 2:24 am

    #328907

    I have a matrix and I need to highlight the background field if it's the max value based on row group.
    in the attached image the highest values is on the UNKNOWN:
    RowGroup1: If the value is max the background color is MidnightBlue
    RowGrou2: if the value is max the background color is MidnightBlue else OceanGreen
    else Grey
    I tried the following formula but it's not working
    =IIF(Count(Fields!WorkOrderCode.Value) = MAX(Count(Fields!WorkOrderCode.Value,"ColumnGroup"),"ColumnGroup"),"MidnightBlue",
     IIF(Count(Fields!WorkOrderCode.Value) = MIN(Count(Fields!WorkOrderCode.Value,"ColumnGroup"),"ColumnGroup"),"OceanGreen",
     "Grey"))

  • April 18, 2017 at 12:36 pm

    #1938645

    I'm guessing the MAX() and/or MIN() aren't working as they're only looking at the one row.  Could you add a CTE to your query to add these max and min values as columns to your query?  Then check if Fields!WorkOrderCode = Field!MaxWorkOrderCode?

    I find it usually easier to get the results in the T-SQL query.

    Just a thought.

    I hope this helps,
    Rob

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply