Calculating Summation in a report based off of a query

[dylcon]

Hello,
I currently have a report that is showing the sum of two different columns that were joined from two different tables. I am trying to get a third column that says the total (total received - total consumed) for each record on the report. I currently have:

=[Sum(SumOfReceivedQuantity)-Sum(SumOfConsumedQuantity)]

in the control source of a textbox that is in the totals column. When I go to open the report, a box comes up asking me to enter the value. I believe this should work how I have it set up. Any help would be appreciated. Thanks!

[NTC]

not sure I fully understand....but do I see brackets around the formula rather than parenthesis?

[dylcon]

I figured it out. I ended up using the expression builder within the control source, which resulted in:

=[SumOfReceivedQuantity]-[SumOfConsumedQuantity]