Line color change and Accumlation

[brf10043]

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

[sunny_talwar]

How about this:

=If(Len(Trim(Avg(IBM_Completed))) > 0, RangeSum(Above(Sum({1}IBM_Completed), 0, RowNo())))

[brf10043]

Now, I'm just impressed!  That works perfectly!

Can't thank you enough for all the help!

[sunny_talwar]

Finally

No problem at all

[#5]

Hello,

Can you send me the example that worked for the accumulation problem. I am currently facing the same difficulty.

Thank you very much !