Counting

[DKirksgirl]

I have created a formula to select specific loans
@SelectBRMo
If Status.Date in LastFullMonth and
Refer.Src.Code in ['BUILDER','REALTOR']
then Ln.Number

Then created a formula to count those loans
@CntLnNoBR
DistincCount({@SelectBRMo},{Prod.Ctr.Name})

I have a group for prod.ctr.name

When the report runs - it counts 1 more - for instance,
I used the same database tables in Access that I am linking to in Crystal and ran the same type query and got 4 records. Crystal counts 5 records

 

[paulmarr]

DKirksgirl,

Depending on the type of database and the way it was setup, there is a possibility that there is a record in there by default. Try DistincCount({@SelectBRMo},{Prod.Ctr.Name})-1.

Cheers,

paulmarr@arcom.com.au

 

[kenhamady]

If everyone in the group qualifies, then you will be one record to low. The problem is that it counts one more value for the Else group. For a better explanation on why this happens and what to do, see my FAQ on common formulas. Look at formula #14. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/