Really stupid calculation in a report question

[Kathleen Badeau]

Is it possible to have a calculation in the detail section of the report that would subtract each line item from a set balance.

i.e., I have a budget amount (in the page header) and in the detail section I have donations made....for each line of the report I want to have the donations made subtracted from the budget amount.

The person I'm doing this report for wants to see the new balance per line item (like a running subtraction) and did not want to see it as a total remaining in the group footer.

 

[mark curtis]

post the db here and it will get looked at

 

[Kathleen Badeau]

Really stupid calculation

What I am trying to attempt to do (and something probably pretty simple) is to have a running balance remaining for every donation made.

Thanks for your help

 

[mark curtis]

See if the attached is along the lines

 

[Kathleen Badeau]

Really Stupid Calculationin a report question

Yes Mark, this is what I am looking for Thank you so much--so much for me to learn

 

[Kathleen Badeau]

Mark, can you explain (so I can learn) how you did the calculation formula?