Percent Quandry

[Charles D Clayton Jr]

I have a report based on a table. The table has a date column that
shows a date for the start of the week. It also has two other
columns. One is Progress (the amount of work we did that week) and
the other is goals (The projected amount of work for that week). The
goals column is just a guess on my part on the amount of work they
should do for that week (taking into consideration various factors
that influence our work). I generate a report that shows these three
columns. It shows the dates for the life of the job (around 6
months), it shows the goals for each week (through the life of the
job) and then it shows the progress up to the present time. Like
this:
Date Goal Progress
11/9 100 125
11/16 125 115
11/23 56 75
11/30 25
12/7 135
11/14 135

What I need to be able to do is to show a percent. I need to add the
total Progress compare that to the total Goals up to that point. So
for this example it would should a total Progress of 315 and total
Goal of 281. This would give me a percent of 112% which shows us
ahead of schedule.

Whenever I do a running sum, it wants to sum all the values in Goals
not just the ones that have a value in Progress (in this case 11/9;
11/16; 11/23). Does anybody have a solution?

Thanks,

Charles D Clayton Jr