Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, I have a line chart that has two run lines. The first is a target line and the second is an actual count line. Both lines are set to Full Accumulation. I would really like to be able to set the line properties of the actual count to be green if above the target line.
in other (non accumulating) charts I used something line this, but it doesn't work properly with accumulation.
if(Sum (IBM_Completed)
>=
Sum (IBM_Planned)
,rgb(69,234,21),rgb(255,0,0) )
Also, is there a way to prevent the accumulation line form showing on future months? I would like to apply the accumulation only to data that already exists.
Thanks
How about this:
=If(Len(Trim(Avg(IBM_Completed))) > 0, RangeSum(Above(Sum({1}IBM_Completed), 0, RowNo())))
Now, I'm just impressed! That works perfectly!
Can't thank you enough for all the help!
Finally
No problem at all
Hello,
Can you send me the example that worked for the accumulation problem. I am currently facing the same difficulty.
Thank you very much !