Hi,
I'm looking to create a formula in Group 1 Footer that sums data from the Group 3 Header and Group 4 Header. I've done variations of this, but always in some way a Sum of a Sum, where the Header level is already in the picklist.
Having a devil of a time getting the syntax right.
Right now I have:
sum({Header 3},{Field}) + sum({Header 4},{Field})
What am I doing wrong? How specifically does Header 3 need to be referenced?
Thanks!
Matt
Hi Matthew,
Do you have already have a Sum on the Group Headers 3 and 4? Are you trying to add these two figures and show the result on Group Footer 1?
If yes, then try this:
1) Create a formula with the code below and place this on the Group Footer #3:
whilepringtingrecords;
numbervar gr3;
gr3 := gr3 + Sum({measure_field}, {group_field_3})
2) Create another formula and place this on the Group Footer #4:
whilepringtingrecords;
numbervar gr4;
gr4 := gr4 + Sum({measure_field}, {group_field_4})
3) Create this formula to display the results on Group Footer 1:
whilepringtingrecords;
numbervar gr4;
numbervar gr3;
gr3 + gr4
4) One last formula to reset the variables and this goes on the Group Header #1:
whilepringtingrecords;
numbervar gr4 := 0;
numbervar gr3 := 0;
Hope this helps.
-Abhilash
Add a comment