Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))))
instead of RGb use standard colurs and see
red() ,green()
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))))
Thanks Vishwarath, that worked like a charm