Grand Total not working with included calculated fields (1 Viewer)

ashkjohnson

Registered User.
Local time
Yesterday, 23:07
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
 

June7

AWF VIP
Local time
Today, 01:07
Joined
Mar 9, 2014
Messages
5,423
Have to repeat aggregate function calcs in report header or footer section.

=Count([Har]) + Count([329D])
 

ashkjohnson

Registered User.
Local time
Yesterday, 23:07
Joined
Dec 5, 2019
Messages
12
Hello June7!
Oh my goodness, it works! Thank you so much! I had tried that formula in a different footer and it didn't work. Wow, I had no idea the placement of the formula in a certain area mattered! Forgive me, I am not a programmer.

Thanks again!!!
Ashley Johnson
 

Users who are viewing this thread

Top Bottom