Conditional Formatting Total Row in Straight Table

[ZoeM]

Hi Community,

I am trying to conditionally format the total rows in my straight table based on a the selections made by the user.

I am using the following expression:

If(RowNo()=0 and Item='PEC',If(Count({<[Issue Category],[Issue Category]={'1. UnContained'},Reference_Only={'No'}>}[Issue Category])>10,RGB(255,0,0),RGB(255,255,255)),

If(RowNo()=0 and Item='PEC',If(Count({<[Issue Category],[Issue Category]={'1. UnContained'},Reference_Only={'No'}>}[Issue Category])<=10,RGB(0,128,0),RGB(255,255,255))

))

When I only have the format 'Red' (>10), it works fine. But when I add the <10, it does not format anything (blank).

Any ideas on what I may be doing wrong?

Thanks in advance

[Chanty4u]

instead of RGb use  standard colurs and see

red() ,green()

[vishsaggi · Accepted solution]

May be try this:

= If(RowNo()=0 and Item='PEC',

        If(Count({<[Issue Category],[Issue Category]={'1. UnContained'},Reference_Only={'No'}>}[Issue Category])>10,RGB(255,0,0),

        If(Count({<[Issue Category],[Issue Category]={'1. UnContained'},Reference_Only={'No'}>}[Issue Category])<=10,RGB(0,128,0),RGB(255,255,255))))

[ZoeM]

Thanks Vishwarath, that worked like a charm