Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
I'm trying to color either the header or the entire column (it doesn't really matter), if the weekday is saturday or sunday. I have the following table, and the following table expression:
=(round((hour(sum({<Day=,[Day of the Week]=>}aggr
(max({<Day=,[Day of the Week]=>}
[time1]-[time2])
, [ID])
))*60+minute(sum({<Day=,[Day of the Week]=>}aggr
(max({<Day=,[Day of the Week]=>}
[time1]-[time2])
, [ID])
)))
/count({< Day=,[Day of the Week]=>}
[Day])))
I'm using this expression to try to color the columns, but it's not working:
if(only({<Day=>}[Day of the Week])='sunday',
RGB(0,0,0))
Any help?
Thanks in advance!
Cheers,
Ines
u can use custom format cell..
there u can give any colur to any cell of ur table.
go o -->view tab---?select --->grid view--->select ur table--->right clik---->select ur cell and give colur
Hi, Actually not, because with custom format cell, conditional formatting is not possible.
Thanks
Hi,
Can you try following expression in background color
if(Match(Only(total<Day>[Day of the Week]),'sunday','saturday'),RGB(0,0,0))
Regards,
Nandkishor Pandirkar
Hi!
Thanks for your reply, but it doesn't work
Cheers,
Ines
Can you attach sample qvw