Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
=if(rangesum(Above(column(4),0,Month))<0.RED(),GREEN())
=if(rangesum(Above(column(4),0,Month))<0.RED(),GREEN())