Counting records

[maxesse]

I have a field which contains some ID's like SE, RT, and so on. These ID define the type of record. I have to obtain a summary at the end which counts how many occurencies of SE I have, how many of RT... Moreover there's another field which identifies the subtype of the ID. If the record is a simple communication it will have a progressive number in this field, if it's a complain it won't have nothing in it.

So I have to obtain a table with a column which indicates the count of communications for a sector (a sector is identified by SE, RT...), a column which indicates the count of complaints and a column for the total.

I've tried with the count() function, with summaries, with getsummary... but I can't figure out how to write the right formula...

Anyone could help me? please...

Thank you in advance

Max

[Ocean West]

You will need a calculation for each type,

cSE Field - [result number]: ID="SE"

This will result in a "1" or True if the ID Field is "SE"

Create one for each type you may have in the ID field

Then create a Summary field that Counts or Totals the cSE field,

and one for every other field you previously created.

To count the Communications it would be:

cSECount - [result number]: ID="SE" and Not isEmpty(Number)

This will result in a "1" or True if the ID Field is "SE" and there is a value in the Number field. You might use something else like is valid or is grather than zero.

Then again create a Sumary field for each of these to count or total.

Hope this helps.

sd

[rivet]

1. Create a self relation based on the id.

2. All records should have a auto variable of 1.

3. Create a sum calc on that related variable.

This solution only requires one new field.

I have posted an example

http://homepage.mac.com/rivet/FileSharing1.html

[ November 25, 2001: Message edited by: rivet ]