Help CR 8.5 count based on critera 2

[wayneCl]

CR 8.5

Need to add a number of count fields to a report.

contact.rec field has either "D" , "A" , "O" Field type string

what im trying to do is count the number of "D" recorders

i have tried count{contact.rec) = 'D'

and other methods with no luck

do a simlar count in R&R reports with no problems just woundered what im doing wrong.

Thanks

 

[bdreed35]

You can do 1 of 2 things.

First option would be to create a running total.
In the running total editor, you would summarize contact.rec, summary type would be count, evaluate using the formula contact.rec = "D", and set up the reset for your situation.

The second option would be to create a formula that evaluates to a 1 or 0 for each record:

if {contact.rec} = "D" then
    1
else
    0

Now create a summary off of this formula.
Insert menu, Summary.
Choose your formula field, then choose Sum as the summary type. Choose the group to group by or leave it alone if it is an overall count.

~Brian

 

[wayneCl]

bdreed35 Thanks alot used the first method and it works thanks again.