Group footer sum of values

G

GL

Hello

In a report’s sub footer I have three text boxes as follow:

1. SubCost = Sum([Cost]) where Cost is a numeric field
2. SubDeduction = IIf([SubDeduction].[Report].[HasData],
[SubDeduction].[Report]![SumofDeduction], 0) where SumofDeduction is a field
in a subreport included in the report’s footer.
3. Cost = [SubCost] – [SubDeduction]

What expression is necessary in the report’s group footer to give the sum of
Cost, I mean the sum of the values of text box 3 of the sub group footer.

Thank you
GL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Subreport totals in a main report Group footer 3
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Summing in a Report Footer 7
Calculate total amt due on an invoice. 9
Totaling Sums for Price and COMM 3
Adding a field (Unbound field) that adds a group of numbers 3
sum totals in report footer 3
Vertically Aligning Fields in a Sub-Report 9

Top