How to Use Count Function in Formula Editor

[amtek]

Hi

How to use Count(fld, condFld, cond) from Function Tree list of functions in Formula Editor.

I am using it as :

Count({Emp.Empno},{Emp.Ename},"=Amit"

But it is giving the error as :

1.The Summary/Running Total Field could not be created.

2.A group condition is not allowed here.

Thanking you,

Amit

 

[dcm]

amtek: 2 points:

1. You may find it quicker to get a response in future if you post queries such as this in the Crystal Decisions: CR Formula forum

2. The answer to your question is that you cannot use this construction of the Count() function within a formula to do a conditional count. You are restricted to only being able to apply a break condition to either a Boolean or a Date Group e.g. if you group by InvoiceDate then you can select to count "monthly" and you'll get a monthly count of invoices. You will need to use a Running Total where you will be able to count subject to your formula David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[kenhamady]

You can also look at FAQ 1.B and see the section on conditional totals. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)