Total Based On Calculated Field

[ramnewbietoaccess]

Happy New Year! I have a report in which I have a field that calculates a January Forecasted Number minus the January Actual number. In the group footer then it totals the January Forecasted and the January Actual. How do I go about totaling the Forecasted-Actual calucated field?

Thank you in advance for any assistance with this.

 

[lupins46]

=Sum([ForecastFieldName]-[ActualFieldName])

Note the calculation uses Fields NOT textboxes.

 

[ramnewbietoaccess]

Thank you that works perfectly. I didnt take into consideration how the footer works.