Full Accumulation and Background Color in a chart

[james]

All -  I have a bar and a line chart created where the line has full accum on it. I created an expression for the background color to be 

if(column(3)-column(2) < 0,RED(),Green()).

The issue is even thought the line is full accum, the expression for colors is only looked at for each month.

Any ideas?

[james · Accepted solution]

=if(rangesum(Above(column(4),0,Month))<0.RED(),GREEN())