Using a running sum in another calculation

[NSTLouis]

I am designing an expense report where one column in the detail section is the running sum of expenses for each account[sumofaccount]. I now want to put a formula in the account footer that calculates [appropriation]- [sumofaccount]. But instead of the final running sum number, the report calculates using the first line of the running sum detail? How do I tell it to use the bottom number and not the first number?

 

[llkhoutx]

Use the same expression for the running sum, not the textbox name, in your calculation.

 

[NSTLouis]

The control source is simply [sumofaccount] and then I have Running Sum in the properties box set to "over group".

So in the footer formula, when I do the same thing, set control source as above, I get only the first number in the running total list instead of the final number. It doesn't matter whether I set the Running Sum property to "no", "over group" or "over all".

Am I missing something in your reply.

 

[dkirk02]

On a report, you can not reference the name of a calculated field in a subsequent calculation. What Ilk is saying is that when you need to reference that calculated field, you have to type out the entire expression again in your sum expression.
Ex:
1st calculated field
=[blah]+[blah]

2nd calculated field as sum of above
=Sum ([blah]+[blah])