Accumulated Line Graph

[#1]

Hi All,

I need to be able to restrict an accumulated line in a chart so the line stops at the max transaction date. It was easy to set the minimum date on the another accumulated line, but i can't use the same method for a maximum date.

I have tried this:

rangesum(above(ProjectTranAmount),Sum(If(vMaxTranDate >= Date,ProjectTranAmount)))

But no luck here.

I'll try to add a picture once the image upload facility is working again.

Thanks.

[#2]

This is the image below:

You can see that there can be no Actual figures beyond the current date (Mar 2010) so the line continues until the maximum calendar date. I want the Actuals line to stop at Mar 2010.