I need a pointer on correctly summi

[elead]

I need a pointer on correctly summing up a count within a group footer

I have one group on the report (szAgentCode)

Here is the formula (cntTRASurveys)for the count:
IIf({tblRaw.lcdate}=DateAdd("d",2,{?ReportStart}) AND {tblRaw.termcd}='SA',1,0)

When I insert a subtotal in the group based on the above formula I only get back a count of 24, there are 121 records meeting the formula criteria in the detail section when I unsuppress it

Any ideas?

thanks

 

[dgillz]

You do not need a formula to count the records. Right click on the field you wish to count in the details section and click on insert summary. Make it a count summary. You're done. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office