Question re: conditional formatting in total column

[Anonymous]

All, in the chart below, I have the background for 'Dials' and 'Talk Time' set as

=if((sum(if(CallDate>weekstart(Today()) and CallDate<=WeekEnd(Today()) and CallDuration>=6,CallDuration))/60/60)>=2.5,RGB(0,255,0),if((sum(if(CallDate>weekstart(Today()) and CallDate<=WeekEnd(Today()) and CallDuration>=6,CallDuration))/60/60)<=1.9999,RGB(255,0,0),Yellow()))

This part is working as intended but I need the background expression to NOT apply to the total column.  I need those to be white.  How can I do this?

[MarcoWedel · Accepted solution]

Hi,

maybe you can try with:

=If(SecondaryDimensionality(),if((sum(if(CallDate>weekstart(Today()) and CallDate<=WeekEnd(Today()) and CallDuration>=6,CallDuration))/60/60)>=2.5,RGB(0,255,0),if((sum(if(CallDate>weekstart(Today()) and CallDate<=WeekEnd(Today()) and CallDuration>=6,CallDuration))/60/60)<=1.9999,RGB(255,0,0),Yellow())))

hope this helps

regards

Marco

[Anonymous]

Thank you SO much!