Group Totals

[brishanny]

I need help computing a formula total.

I need to total a number for each record in a particular group.

How can I get a total at the end of the report for where GroupHeader #2 = the value 1. So if the value of GroupHeader #2 = 2 or 3 or 4 I want to ignore the value.

If this doesn't make sense please let me know.
Thanks

 

[MColeman]

You could add a formula to the group header you want to count:

@countgroup1
whileprintingrecords;
if GroupName ({LBQ00102.Wennsoft_Branch}) = 1 then
shared numbervar mygroupcount : = mygroupcount + 1

then at the end of the report in the report footer or final total line

@displaygroupcount
whileprintingrecords;
shared numbervar mygroupcount;
mygroupcount

 

[brishanny]

Thanks for your reply. I have a couple questions about your suggestion since I am a rookie.

What do these do or what is their purpose:
@countgroup1
@displaygroupcount

Also can this value 'mygroupcount' be use in a formula?

Thanks!

 

[MColeman]

oops...

These "@countgroup1 @displaygroupcount" are just the
names I gave the formulas in my testing, they are not
a part of the formulas themselves.