ashkjohnson
Registered User.
- Local time
- Today, 01:24
- Joined
- Dec 5, 2019
- Messages
- 12
Hello,
I am having difficulty with creating a final, grand total on my report. In my report I have groups that have their own subtotals. I would like to take those earlier subtotals and sum them for a grand total. In each group, I have on my report a section including three text fields and their respective count calculations:
Name ................... Calculation in Field
1. txtCountHAR ................... =Count([HAR])
2. txtCount329D .................. =Count([329D])
3. txtTotal...................... =[txtCountHAR]+[txtCount329D]
I want a grand total including a sum of all fields from fields named txtTotal.
I know the calculated fields do not hold the reported values and that a calculation expression is required. But, I can't seem to figure out the correct calculation.
Any help will be great! Thanks in advance!
-
Ashley Johnson
I am having difficulty with creating a final, grand total on my report. In my report I have groups that have their own subtotals. I would like to take those earlier subtotals and sum them for a grand total. In each group, I have on my report a section including three text fields and their respective count calculations:
Name ................... Calculation in Field
1. txtCountHAR ................... =Count([HAR])
2. txtCount329D .................. =Count([329D])
3. txtTotal...................... =[txtCountHAR]+[txtCount329D]
I want a grand total including a sum of all fields from fields named txtTotal.
I know the calculated fields do not hold the reported values and that a calculation expression is required. But, I can't seem to figure out the correct calculation.
Any help will be great! Thanks in advance!
-
Ashley Johnson