Charting 'Hard-Coded' Budget periods (confused)

[brendanj68]

Hi,

Running CR9/ SQL2000. The following represent some budget periods that needed to be 'hard-coded' for another purpose, now I've been instructed to represent this data in a line chart which is manipulated through a date range parameter. What I would like therefore is as per a budget period/ against project value calculation, that these budget figures are cumulativly (calculated) depending on the date range selected. I have tried as many variations to get this to work, but am out of luck. Any suggestions would be a real help. FYI my financial year runs 01/Apr/x to 31/Mar/x, hence the structure.

Thanks

if year({PLR____Support_All.Start_Date})=2003 then
select month ({PLR____Support_All.Start_Date})
case 4 : 19000
case 5 : 0
case 6 : 15000
case 7 : 102000
case 8 : 198000
case 9 : 173714.285
case 10 : 173714.285
case 11 : 173714.285
case 12 : 173714.285
else if year({PLR____Support_All.Start_Date})=2004 then
select month ({PLR____Support_All.Start_Date})
case 1 : 173714.285
case 2 : 173714.285
case 3 : 173714.285
default : 0;

 

[lbass]

Try using the date range parameter as the record selection formula:

{table.date} = {?date}

Then keep your formula (let's call it {@budget}) as is, and create a second formula {@accum}:

numbervar accum := accum + {@budget}

{@accum} should be available for charting.

-LB