Accumulation behaviour - set a max accumulation date

[#1]

Hi All,

I wish to accumulate an actual spend amount over a date period in a line graph.

The problem is that the line extends to the maximum date (horizontally). I want the line to stop at the maximum actual spend date, not the maximum date on my date calendar.

See below:-

So here, the blue line (Actual) will stop at Mar 2010.

How is this possible?

Thanks!

[deepakk]

If possible can you attach a sample application

[#3]

Hi

I have done it like this

sum

(if(month(Budget_date) = month(Actual_date) and year(Budget_date) = year(Actual_date),Actual_value))

It works for me.

Anders